there are implicit and explicit cursorswhich one were you trying to do?
If you use an implicit cursor, you do not need to OPEN, FETCH INTO, and CLOSE cursor. The pl/sql engine will do that for you.
Nick Han
>>> [EMAIL PROTECTED] 03/15/04 12:43PM >>>
After I've executed an Oracle Stored pr
Deanna Schneider wrote:
> My understanding is that if you use a cursor "for" it gets closed
> implicitly.
> I've used this syntax before (without closing) successfully:
> BEGIN
> OPEN mycursor FOR
> select blah blah;
> END;
That makes sense to me. It's what I've been assuming as well.
--
Richa
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 2:43 PM
Subject: Even more CF and Oracle stuff: Closing a cursor
> After I've executed an Oracle Stored procedure and brought the results
> into Cold Fusion, is there a way to close the ref cursor within Cold
&g
After I've executed an Oracle Stored procedure and brought the results
into Cold Fusion, is there a way to close the ref cursor within Cold
Fusion? I've tried calling a second stored procedure that closes the
cursor, but this doesn't seem to do the trick.
Is it even necessary to close the curs
4 matches
Mail list logo
