LOB morethan 4K error [message #2610] |
Wed, 31 July 2002 00:13 |
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 |
|
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.
|
|
|