I got this task of importing a few hundreds of images into existing rows containg empty blob column. Each row contains field FILENAME so I can determine which image to load into each BLOB field.
Usual way of doing such things involves loading images onto server and then using oracle DIRECTORY and DBMS_LOB.
Unfortunately I cannot do that. Loading the files onto the server is not an option, I must do it directly from client.
One option is to write an one-off prog that will connect to oracle server, SELECT xxx FOR UPDATE the BLOB and then load blob from files.
What I'd prefer is not writing such one-off program from scratch but use some existing tool that can already load blobs from client machine. PLSQLDEveloper can do it, but only one file at a time and with user interaction.
Is there some way of scripting/automating this PLSQLDeveloper blob loading functionality?
Usual way of doing such things involves loading images onto server and then using oracle DIRECTORY and DBMS_LOB.
Unfortunately I cannot do that. Loading the files onto the server is not an option, I must do it directly from client.
One option is to write an one-off prog that will connect to oracle server, SELECT xxx FOR UPDATE the BLOB and then load blob from files.
What I'd prefer is not writing such one-off program from scratch but use some existing tool that can already load blobs from client machine. PLSQLDEveloper can do it, but only one file at a time and with user interaction.
Is there some way of scripting/automating this PLSQLDeveloper blob loading functionality?
