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 -> cursor in a stored procedure

cursor in a stored procedure

From: Steve A <spectre_at_hkstar.com>
Date: Fri, 3 Sep 1999 17:18:19 +0800
Message-ID: <1dxkfxt.kw9b6kp9fda8N@[201.1.1.73]>


Hi,
I setup a stored procedure that writes to a file from a cursor. but it is necassary to make 3 passes thru the cursor data. do I really have to close the cusor then re open it before I can do the next loop,
 it seems if i do not close & reopen it, the other 2 passes don't write anything.

steve Received on Fri Sep 03 1999 - 04:18:19 CDT

Original text of this message

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