Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error ORA-01000: Maximum Open Cursors Exceeded in CLOSE_THIS_WINDOW referenced trigger
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