Re: ora-01002 fetch-out-of-sequence (report 2.5)

The fetch-out-of-sequence occurs when you are using cursors in a loop and the cursor is defined 'for_update'. If in your loop, you issue a COMMIT, you will get the fetch out of sequence message. Well, thats the case in PL/SQL anyway.
IF you are getting this in a report, check that you do not have any commits in report level triggers (e.g Between_Page triggers etc).

Hope this helps.

Mark

ssts wrote in message <36DC8CF2.8572DA9A_at_pacific.net.sg>...
>Hi, i'm facing the above error when i ran the report on the customer's
>workstation. I had try to run few times i found that this error is not
>occur sometime. i wanted to know what the reason? Is it because the
>query problem? I have a simple query like :
>
>select transaction.custcode, master.custname, ...
>from transaction, master
>where transaction.custcode = master.custcode;
>
>Hope somebody give me some hint .
>Thanks!
>
Received on Wed Mar 03 1999 - 09:53:49 CST