DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-22990: LOB locators cannot span transactions

  1. #1
    Join Date
    Nov 2002
    Location
    hydreabad
    Posts
    34

    ORA-22990: LOB locators cannot span transactions

    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
    Venkata vara Prasad Kosaraju

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

    Re: ORA-22990: LOB locators cannot span transactions

    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

  3. #3
    Join Date
    Dec 2004
    Location
    India
    Posts
    1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width