Re: Explicit Cursor Commits

Because a commit closes the cursor. What you should is select all the data you
need, including the internal key. Order by internal key, and write your cursor in a
way that it will only include those rows that are greater than parameter. First
time open with a value lower than all internal keys.

Before the commit: close the cursor, commit, open cursor with the internal key
before the close as parameter.

Good luck!
Jean-Luc

Doug Cowles wrote in message <35CB86C7.EC0CE1ED_at_i84.net>...
>Why does a fetch out of sequence error occur when a commit is done
>inside of a fetch loop of an open cursor? (pl/sql)
>
>Dc -
>
>
>
Received on Mon Aug 10 1998 - 15:26:26 CDT