OCI Max Cursors Exceeded

From: Leigh Warren <leighw_at_midsys.co.uk>
Date: Thu, 13 Jan 2000 11:36:47 -0000
Message-ID: <85kdb6$e1q$1@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 - 05:36:47 CST