Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: got max open cursor err in vb6 application

    Hi,

    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.

    Any input would be greatly appreciated.

    Regards,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It might help if you explicitly closed the DBLINK when you are done using it.

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Originally posted by anacedent
    It might help if you explicitly closed the DBLINK when you are done using it.
    What do you mean?

    Any connection I have will only be closed on exit out of the application.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •