asked on

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)

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

neerajmanayil

ASKER

My application is deployed on multiple servers and Oracle is on rac servers with load balanced.

slightwv (䄆 Netminder)

From the error code description, looks like you have an Oracle version issue that only hits the 'bad' combination once in a while.

neerajmanayil

ASKER

Is the Oracle Version discrepancy the only cause for this issue? Or can it be caused by any other reason?

slightwv (䄆 Netminder)

I have to go by the error code.

Everything I can find, even in Oracle Support, points to a version mismatch.