Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-24816 error with oracle 10 driver

421873Aug 22 2006 — edited May 4 2007
Friends,

I am getting the following error with Oracle 10 driver while trying to insert data > 4k into a LONG column. The table also contains another column of type varchar2(4000). The code works perfectly fine with Oracle 9i driver.

ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

Kindly let me know if this is a programming error or a driver problem.

From the description of the error code it looks like a programming error but then why did it run successfully with oracle 9i jdbc driver?

ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
Cause: A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG.
Action: Re-order the binds so that the LONG bind or LOB binds are all at the end of the bind list.

Thanks,
Vinay

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 1 2007
Added on Aug 22 2006
#java-database-connectivity-jdbc
10 comments
41,923 views