Originally posted by prasadkvv
Hi
When i am trying to insert a clob into the datbase using the java
CLOB clob = ((OracleResultSet) rs).getCLOB("XMLDATA");
Writer tempClobWriter = clob.getCharacterOutputStream();
tempClobWriter.write(data);
tempClobWriter.flush();
tempClobWriter.close();
Ima ggetting the java.io.IOException: ORA-22990: LOB locators cannot span transactions

Pl give the suggestions

Thans & Regards
Venkata
Error: ORA-22990 Text: LOB locators cannot span transactions
----------------------------------------------------------------------
Cause: A LOB locator selected in one transaction cannot be used in a different transaction.
Action: Re-select the LOB locator and retry the operation.

metalink note 113666.1 as well