ORA-22990: LOB locators cannot span transactions

[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

[davey23uk]

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

[jagannadham]

After obtaining the clob for update from the database and prior to populating the clob with the data, the same clob data is being accessed. Pls. check this.