Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question about cursors

Question about cursors

From: Syltrem <syltremspammenot_at_videotron.com>
Date: Thu, 4 Apr 2002 12:39:10 -0500
Message-ID: <Rb0r8.6165$a04.31772@tor-nn1.netcom.ca>


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 address
Received on Thu Apr 04 2002 - 11:39:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US