neerajmanayil
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/o jdbc5.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.SQLStat eMapping.n ewSQLExcep tion(SQLSt ateMapping .java:70)
at oracle.jdbc.driver.Databas eError.new SQLExcepti on(Databas eError.jav a:131)
at oracle.jdbc.driver.Databas eError.thr owSqlExcep tion(Datab aseError.j ava:204)
at oracle.jdbc.driver.T4CTTIo er.process Error(T4CT TIoer.java :455)
at oracle.jdbc.driver.T4CTTIo er.process Error(T4CT TIoer.java :413)
at oracle.jdbc.driver.T4C8Oal l.receive( T4C8Oall.j ava:1034)
at oracle.jdbc.driver.T4CPrep aredStatem ent.doOall 8(T4CPrepa redStateme nt.java:19 4)
at oracle.jdbc.driver.T4CPrep aredStatem ent.execut eForRows(T 4CPrepared Statement. java:953)
at oracle.jdbc.driver.OracleS tatement.d oExecuteWi thTimeout( OracleStat ement.java :1222)
at oracle.jdbc.driver.OracleP reparedSta tement.exe cuteIntern al(OracleP reparedSta tement.jav a:3387)
at oracle.jdbc.driver.OracleP reparedSta tement.exe cuteUpdate (OraclePre paredState ment.java: 3468)
at oracle.jdbc.driver.OracleP reparedSta tementWrap per.execut eUpdate(Or aclePrepar edStatemen tWrapper.j ava:1062)
My application uses:
Oracle/11.1.0.7/jdbc/lib/o
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.SQLStat
at oracle.jdbc.driver.Databas
at oracle.jdbc.driver.Databas
at oracle.jdbc.driver.T4CTTIo
at oracle.jdbc.driver.T4CTTIo
at oracle.jdbc.driver.T4C8Oal
at oracle.jdbc.driver.T4CPrep
at oracle.jdbc.driver.T4CPrep
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleP
at oracle.jdbc.driver.OracleP
at oracle.jdbc.driver.OracleP
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
From the error code description, looks like you have an Oracle version issue that only hits the 'bad' combination once in a while.
ASKER
Is the Oracle Version discrepancy the only cause for this issue? Or can it be caused by any other reason?
I have to go by the error code.
Everything I can find, even in Oracle Support, points to a version mismatch.
Everything I can find, even in Oracle Support, points to a version mismatch.
ASKER