Re: Stored Procedure Question

On Mon, 05 Aug 2002 02:23:21 -0800, Gavin wrote:

>I know this is trivial but in my quest for solving an open_cursor problem in
>Oracle8i I have noticed that unnamed cursors do not get closed. The first
>statement calls a package which calls an unnamed cursor, increases the
>number of open cursors by 1.

I'd be interested in knowing more about this particular aspect of your query. I recently had occasion to delve into PL/SQL cursor handling (see http://gennick.com/open_cursors.html). Does your packaged function open a cursor without closing it? If the source isn't too complex, I'd be interested in seeing it.

Jonathan Gennick --- Brighten the corner where you are mailto:jonathan_at_gennick.com * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  INET: listmail_at_gennick.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).