Maximum Open Cursors Exceeded ?? - HELP

[krpd]

Hi,

I am working on a VB - Oracle application. I get this error "Maximum Open Cursors Exceeded", when ever i query for different records more than 25-30 times. Since this is a multiuser App. I am using a DYNAMIC cursor for all operations and a STATIC cursor for display only. ( - basically opening ADO Recordsets thru code)

I am not sure how to CLOSE a cursor, or does it implicitly get closed in VB when the RECORDSET is closed or SET equal to NOTHING ??

How do i know whether a cursor is Closed or not ??

Please help ...

Prabhu Dev

 

[andreigogan]

The cursor is closed when you are closing the recordset..

Otherwise, you can configure the Oracle server to suport an larger number of connections (in the ini file of the instance of the Oracle Server)