Fetch out of sequence(?) 1

[cecilcheah]

Hi All:

Anyone know what is the error message:

ORA-01002: fetch out of sequence

means? and what i can do to solve it?

Thanks

Cecil

 

[sem]

You've probably tried to fetch from 'for update' cursor after commit or rollback.

 

[cecilcheah]

No, nothing fancy. I use Oracle 8.0 and my SQL is onyl:

Select something
From something table
where something = something.If you need the exact query, i can post it.

Nothing fancy.

Any other help?

Cecil

 

[sem]

What product do you use? Is this query a part of pl/sql code or block base query in Forms?

 

[cecilcheah]

I am using Oracle SQL Plus v8. The query is normal SQL query.

Do you need to see the actual SQL?

Cecil

 

[sem]

Try to trace your session. This error may be generated by some other statements issued by sql*plus itself.

 

[djmartin]

If it is a Record Group / LOV problem play with the Record Group Fetch Size, try very big, or very small, depending on how many records you are expecting to get back.

Otherwise, try changing the Query Array Size, set it to 0.

David

 

[gregburningham]

Please show me the SQL ....