My Oracle Support Banner

ORA-24816 Error Occurs When Attempting To Insert LOB Data Bigger Than 2000 Bytes in Length Using 12c OCI Driver (Doc ID 2337144.1)

Last updated on MAY 31, 2023

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


In JDBC OCI when attempting to insert data into a table that contains LOBs bigger than 2000 bytes, the following error is received:

Exception in thread "main" java.sql.SQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

at oracle.jdbc.driver.T2CConnection.checkError(
at oracle.jdbc.driver.T2CConnection.checkError(
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(



Rearranging the order of the SQL per <Document 746333.1> ORA-24816 On Insert Statement does not work.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.