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: Robert Ottohall <ottohall_at_hotmail.com>
Date: Thu, 22 Oct 1998 07:02:29 +0200
Message-ID: <70medq$knv$1@goof.de.uu.net>


Hi David,
may be thast's the reason:
 the error occurs when your procedure or trigger do not commit transactions ( insert,udate..).

David Mulligan wrote in message <362E6BE0.7CC03B93_at_goodnet.com>...
>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 Thu Oct 22 1998 - 00:02:29 CDT

Original text of this message

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