Blob
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Blob

  1. #1
    Join Date
    Mar 2002
    Posts
    46

    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

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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
  •  



Click Here to Expand Forum to Full Width