Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored procedure failed: maximum open cursors exceeded

Re: Stored procedure failed: maximum open cursors exceeded

From: Joel Garry <joel-garry_at_home.com>
Date: 26 Jan 2006 11:28:54 -0800
Message-ID: <1138303733.952331.275550@g47g2000cwa.googlegroups.com> 





See implicit cursors:


http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/06_ora.htm#1405



You can use OEM to look at the cursors oracle says you have open in a
session.



What do you get when you


SQL>SHOW PARAMETER CURSOR


jg

-- 
@home.com is bogus.
http://www.testecvw.com/andrea/images/dave.jpg


Received on Thu Jan 26 2006 - 13:28:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US