Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!feed.cgocable.net!feed.tor.primus.ca!feed.nntp.primus.ca!tor-nx1.netcom.ca!tor-nn1.netcom.ca.POSTED!not-for-mail From: "Syltrem" Newsgroups: comp.databases.oracle.server Subject: Question about cursors Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Thu, 4 Apr 2002 12:39:10 -0500 NNTP-Posting-Host: 66.46.84.130 X-Complaints-To: abuse@attcanada.ca X-Trace: tor-nn1.netcom.ca 1017941873 66.46.84.130 (Thu, 04 Apr 2002 12:37:53 EDT) NNTP-Posting-Date: Thu, 04 Apr 2002 12:37:53 EDT Organization: AT&T Canada IES Xref: easynews comp.databases.oracle.server:142062 X-Received-Date: Thu, 04 Apr 2002 10:35:47 MST (news.easynews.com) 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