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 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]
