I cannot for the life of me figure out how to successfully insert a file into a blob column in a DB, using a PL/SQL script.
Should be able to reuse this script indefinitely, preferably, with several files at the same time, but as long as I can do one, I'll be fine with it.

I do not have permissions to create a directory, so something like this:

--!START
CREATE OR REPLACE DIRECTORY blobfile_dir AS 'C:\Users\wyatt\Desktop\test';
/
--!END

Will NOT work.


There has to be another way to insert a file, into a blob column without the need to create a directory and without having to manually add it into the column through SQL Developer. I'm just unable to figure out what that way might be.

Any ideas?