Ref Cursors Resultsets and ADO

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: 2000/08/10
Message-ID: <8mtpfs$dbg$1@kermit.esat.net>#1/1

I currently have tested returning a resultset from ADO (both 2.1 and 2.5) , using a stored procedure returning a Ref Cursor.

After the procedure is called 50 times, an Oracel error is returned (Two many open cursors).

The max no of open cursors is set to 50 in my Database (probably the Default).

Presumably this is beacuse ADO does not close the cursor. Is there anything I can do on the server side to overcome this limitation. I sit possible to close a ref cursor if it is open. What is the potential impact.
What is a sensible no of open cursors to have for a 350 user system

TIA Received on Thu Aug 10 2000 - 00:00:00 CDT