Home > IT Answers > Business Intelligence > CLOB – Fetch out of sequence
GinaOL
0 pts.
 CLOB – Fetch out of sequence
Database Management Systems, Development, J2EE, Java, Lifecycle development, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, SQL, XML
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...

Software/Hardware used:
ASKED: March 3, 2005  10:48 AM
UPDATED: March 3, 2005  11:26 AM
RELATED QUESTIONS
Answer Wiki:
You may get this error when you use "select from .. update" statement after issuing a commit. Once commit is executed, the cursor status is no longer valid and hence the error. You have two options. Do not commit or re-open the cursor. HTH
Last Wiki Answer Submitted:  March 3, 2005  11:26 am  by  Rpower3   0 pts.
All Answer Wiki Contributors:  Rpower3   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _