Re: ORA-01002 Fetch out of Sequence.
From: Alastair Newson <anewson_at_cix.compulink.co.uk>
Date: Mon, 26 Sep 1994 10:07:07 GMT
Message-ID: <CwqErw.M0v_at_cix.compulink.co.uk>
Date: Mon, 26 Sep 1994 10:07:07 GMT
Message-ID: <CwqErw.M0v_at_cix.compulink.co.uk>
This can be caused by a cursor loop loosing control if a commit is made.
ie. You've got a cursor loop in some code that iterrates. Every so often
the right conditions are met and some sneaky if statment decides its time
to do a commit. The next time you go back for a row from the cursor
loop.
ORA-01002 pops-up.
It may be caused by other things, but thats the one I know about and it
took about a week to focus down on exactly what was causing it.
Alastair Newson 'When the best leader's work is done, Technical Projects Manager the people say, Glaxo Pharms UK Ltd "We did it ourselves!"'44-81-990-3023 Received on Mon Sep 26 1994 - 11:07:07 CET