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