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?


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