How can an Oracle client can load data into BLOB column? I don't want to create a directory, copy the file on the server and then use the dbms_lobs.loadfromfile to insert the value of the BFILE in the BLOB column. It takes to much time and I don't want a copy of those file on the server.
How can the client can send the byte directly into the blob column?
I work with Orale 8.1.7 on a DEC unix server
You can do it only by using OCI functions.
I can give you small program which load data into the table:
create table filesafe
(FILENAME VARCHAR2(100) NOT NULL,
CHANGETIME DATE NOT NULL,
After you load you data you can manipulate it as you wish.
Unfortunately it more than 100K and I can only send it to you by email.
Click Here to Expand Forum to Full Width