Re: OCI Max Cursors Exceeded

From: Peter Winters <peterw_at_trinitysoftware.com.au>
Date: Fri, 14 Jan 2000 12:52:59 +1000
Message-ID: <newscache$pc1bof$bun$1@news.iig.com.au>

Try increasing the maximum number of open_cursors. This is achieved via a parameter in the initSID.ora file, as follows.

open_cursors=256
or what ever it take, from memory I think there is limit..

Regards
Peter Winters
Cairns, Queensland AUSTRALIA

Leigh Warren <leighw_at_midsys.co.uk> wrote in message news:85kdb6$e1q$1_at_soap.pipex.net...
> Hi,
>
> I'm using OCI with REF CURSOR which I open and subsequently close many of
on
> the same connected but I run out of cursors after using several hundred of
> them on certain stored procedures. These procedures have 2 reference
> cursors as their arguments and it seems as if only one of them ever get
> released after each call. I definately do attempt to close all cursors
and
> I receive no error messages from the close handle call.
>
> Leigh..
>
>
Received on Thu Jan 13 2000 - 20:52:59 CST