java.sql.SQLException: ORA-24813: cannot send or receive an unsupported LOB

I am getting an error "java.sql.SQLException: ORA-24813: cannot send or receive an unsupported LOB" when my java application tries to insert or update a XML into a CLOB Oracle column.

My application uses:

Oracle/11.1.0.7/jdbc/lib/ojdbc5.jar
Oracle 10g Database.
Java 6.

This is happening only intermittently. It is working fine other users on the same server so it doesn't seems to be an issue with Oracle client or server that my application uses.

java.sql.SQLException: ORA-24813: cannot send or receive an unsupported LOB

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
neerajmanayilAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Do you have multiple servers?  Maybe load balanced?  If so, check their Oracle versions.

http://ora-24813.ora-code.com/
0
 
neerajmanayilAuthor Commented:
My application is deployed on multiple servers and Oracle is on rac servers with load balanced.
0
 
slightwv (䄆 Netminder) Commented:
From the error code description, looks like you have an Oracle version issue that only hits the 'bad' combination once in a while.
0
 
neerajmanayilAuthor Commented:
Is the Oracle Version discrepancy the only cause for this issue? Or can it be caused by any other reason?
0
 
slightwv (䄆 Netminder) Commented:
I have to go by the error code.

Everything I can find, even in Oracle Support, points to a version mismatch.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.