Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Closing cursors after leaving them open.
Fernão Magalhaes doodled thusly:
>I tried running an anonymous PL/SQL procedure several times, without
>closing the cursor, and it executed successfully. Can you clarify how
>you arrived to the error below?
>
I think galen would have been running a stored procedure. Anonymous blocks close everything on exit. Packages can remain with active status.
A simple IF for cursor open is needed. If anyone interested, I can post here some sample code? Got it all over the place for "getters" I'm doing for J2EE screens.
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sun Jan 27 2002 - 19:56:37 CST