Re: ORA-01002 Fetch out of sequence

Roy Brokvam wrote:
>
> Paul Simmons wrote in message <373781CD.8A25F779_at_death.iinet.net.au>...
>
> [snip]
> >More to the point it is good to remember that any commit before a cursor
> >is closed will close the cursor(s)

> No, that's not correct. The cursor remains open after a COMMIT/ROLLBACK. A
> COMMIT makes changes permanent, then releases row locks. A ROLLBACK undoes
> changes, then releases row locks. Period.

<Just knocked up a quick test prog and ...>

It appears that you are correct. My ideas may have stemmed from when I was writing embedded SQL with ingres (which does work like I said), however oracle does not.
--
Regards

Paul Simmons Received on Tue May 11 1999 - 21:13:41 CDT