Guest_imported
New member
- Jan 1, 1970
- 0
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
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
