Re: Cursor still opened?

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: Fri, 20 Nov 1998 13:57:25 -0000
Message-ID: <733seh$ngf$1@schbbs.mot.com>

If you write your PL/SQL anything at all like mine then you may find a number of routes through the code in which you might need to close the cursor.

Perhaps your route is going into the exception handler in which case you'll need to close the cursor in there as well. I've forgotten this a number of time myself.

--
Alan D. Mills

suisum_at_ecn.ab.ca wrote in message <36554a9b.0_at_ecn.ab.ca>...
>I use explicit cursor. I close it after use. But it still opened for some
>reason. Any idea?
>
>--
>Best regards,
Received on Fri Nov 20 1998 - 07:57:25 CST