Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g44g2000cwa.googlegroups.com!not-for-mail From: "Helge Moulding" Newsgroups: comp.databases.oracle.tools Subject: Re: Too Many Cursors? Date: 4 Oct 2005 08:56:34 -0700 Organization: http://groups.google.com Lines: 12 Message-ID: <1128441394.256962.173240@g44g2000cwa.googlegroups.com> References: <1128382200.440481.132820@f14g2000cwb.googlegroups.com> NNTP-Posting-Host: 155.101.189.44 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1128441399 20653 127.0.0.1 (4 Oct 2005 15:56:39 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 4 Oct 2005 15:56:39 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: g44g2000cwa.googlegroups.com; posting-host=155.101.189.44; posting-account=-u2TwAwAAACXgK0Txs5INBKCuxnXL2Hi Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:69352 Yuri Ivanov wrote: > May be you can increase OPEN_CURSORS parameter in your instance? Thanks, Yuri. I did consider that. The trouble with that, of course, is that it assumes that the function I wrote opens only a normal number of cursors. It looks to me that there's a problem with that assumption. -- Helge Moulding hmoulding at gmail dot com Just another guy http://hmoulding.cjb.net/ with a weird name