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]

Reply via email to