0 Replies Latest reply on Apr 17, 2009 4:51 AM by timo.trautmann

    Inserting a BLOB or CLOB Into an Oracle DB using ADBC

    timo.trautmann Level 1

      Hi,

       

      I'm trying to import the attachments of a PDF document into a Oracle XE database.

       

      At current I could not figure out how to  do this by using a BLOB object.

       

      I could import the files into an CLOB object (BASE64 encoded), but this fails if the size of the encoded string is too large . I guess I could only transfer 32k inside a insert statement.

       

      Any help would be appreciated.

       

      Thanks

      Timo