Home » SQL & PL/SQL » SQL & PL/SQL » LOB morethan 4K error
LOB morethan 4K error [message #2610] Wed, 31 July 2002 00:13 Go to next message
Achyuth B
Messages: 8
Registered: November 2000
Junior Member
Hello,

We are using Oracle Thin Driver in JDBC to insert data into BLOB. We are getting error in inserting more than 4K data in BLOB, the chunk size we have set is 8k...

Though we are inserting large object (>4K) by splitting into individual 4K's, we are getting the error.

We are not able to proceed further. Please help me in this regard if any knows solution about this. This is very urgent...!!!!

Thanks in advance.

Best Regards,
Achyuth
Re: LOB morethan 4K error [message #2611 is a reply to message #2610] Wed, 31 July 2002 02:44 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Oracle has created extension classes (oracle.sql.BLOB, oracle.sql.CLOB) with methods to write data to BLOBs. It is recommended that you use the methods in the oracle.sql.BLOB and oracle.sql.CLOB classes when dealing with LOBs.
Refer to the "8.1.6 JDBC Developers Guide", Chapter
7, and the "Application Developers Guide - Large Objects" for details.
Previous Topic: EXECUTE IMMEDIATE
Next Topic: Loops and varchar parsing
Goto Forum:
  


Current Time: Thu Apr 25 13:11:45 CDT 2024