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 -> Q: How to rewind cursor in PL/SQL?

Q: How to rewind cursor in PL/SQL?

From: Alexandre Ziablitsev <101.41593_at_germanynet.de>
Date: 1997/12/10
Message-ID: <66mcf1$pte$1@news.seicom.net>#1/1 







Hi!



I'm writing procedure in PL/SQL for ORACLE 8.
I need to run the same SQL statment in a loop, in witch I reopen the 
cursor everytime I get to the head of loop. The cursor parameters 
doesn't change. 



Is it possible to rewind opened cursor to save the time and don't 
open the cursor for reading the database each time getting the head 
of the loop after closing this cursor at the loop bottom ?



thanks.



    Alex Ziablitsev
Received on Wed Dec 10 1997 - 00:00:00 CST












Original text of this message













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