Unanswered: got max open cursor err in vb6 application
I get this "ORA-01000: maximum open cursors exceeded
ORA-02063: preceding line from NDSD -1" error whenever I exceed the open cursor limit (100) which defined in the INIT.ORA. It seem error mainly happens when retrieving data via db link.
The application is written in vb 6. It connects to oracle via jdbc driver and retrieves data via ref_cursor/vb recordset.
I tend to set the recordset to nothing whenever I'm through with the data. However it seem that oracle does not recognise that the cursor has been destroyed by VB.
The reason why I know this is because on running the query (below) in the external database, the statistics for open cursors (database link) does not decrease when setting the recordset to nothing.
select * from v$sysstat
where name like '%opened cursors current%'
What I don't understand is that why does the cursor remained open (db link) eventhough the recordset is set to nothing.