1 Reply Latest reply: Feb 6, 2014 7:38 AM by kgronau RSS

Using Oracle ODBC HS to Sybase get max cursors exceeded

tx103108 Newbie
Currently Being Moderated

Oracle 11gR2

Linux RHEL 6.5

-----------------------

 

When using Oracle ODBC HS to connect to Sybase via dblink SYB getting the following error:

ORA-01000: maximum open cursors exceeded

ORA-02063: preceding line from SYB

 

When running the same SQL locally, getting no errors.  (The same tables in Sybase are replicated in Oracle.)

 

Increased max cursors ten-fold and even restarted Oracle -- no difference.  SQL against system tables shows not more than 250 cursors in use yet max cursors set to 2500.

 

Does this error above suggest a max cursor problem with Sybase?  Or something else?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points