| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Question about cursors
This is an easy one, but I haven't yet found the answer in the doc (still
looking)
When is a cursor implicitely closed ?
I can close it explicitely with the CLOSE verb, but does it get closed as soon as we exit from the procedure that created/opened it? Can we call the procedure in a loop, and each time get, say, the next row from that cursor? That's what I would need to do. If that isn't possible then I would have to do a select where key > previous_key or something like this in that cursor and reopen the cursor every time the procedure is called.
Thanks.
-- Syltrem http://pages.infinit.net/syltrem (OpenVMS related web site - en français) To reply to myself directly, remove .spammenot from my addressReceived on Thu Apr 04 2002 - 11:39:10 CST
![]() |
![]() |