-
Blob
Hi,
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
Thanks
-
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,
DATA BLOB);
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.
Best wishes!
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|