I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like:
select XML_DATA from XML_TABLE where SESSION_ID = ? FOR UPDATE
Please help me resolve this...
March 3, 2005 10:48 AM
March 3, 2005 11:26 AM