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;
----- Original Message -----
From: "Richard Crawford" <[EMAIL PROTECTED]>
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
> 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 cursor?
>
> --
> Richard S. Crawford
> Programmer III,
> UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
> (916)327-7793 / [EMAIL PROTECTED]
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Even more CF and Oracle stuff: Closing a cursor Richard Crawford
- Re: Even more CF and Oracle stuff: Closing a cursor Deanna Schneider
- Re: Even more CF and Oracle stuff: Closing a cur... Richard Crawford
- Re: Even more CF and Oracle stuff: Closing a cursor Nick Han