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: Error ORA-01000: Maximum Open Cursors Exceeded in CLOSE_THIS_WINDOW referenced trigger

Re: Error ORA-01000: Maximum Open Cursors Exceeded in CLOSE_THIS_WINDOW referenced trigger

From: John Durst <jdurst_at_sky.net>
Date: Wed, 21 Oct 1998 19:04:21 -0500
Message-ID: <362E7684.6B1EDB73@sky.net> 





There is a database parameter called OPEN_CURSORS that needs to be
increased.



David Mulligan wrote:



> When I compile a form that I have created a get a compilation error


> "ORA-01000: Maximum Open Cursors Exceeded".  If I "goto the error" it is


> in the referenced trigger CLOSE_THIS_WINDOW.  Since this a referenced


> trigger, I can not delete or modify it.  I have heard that this error is


> common, but no one has yet told me how to fix it.


>


> Any help is greatly appreciated.





Received on Wed Oct 21 1998 - 19:04:21 CDT












Original text of this message













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