Re: Trigger error: Too many open cursors

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 17 Jan 2006 03:23:53 -0800
Message-ID: <1137497033.715754.203230@g47g2000cwa.googlegroups.com>

First of all, there is no message 'Too many open cursors'.

There is:

ORA-01000 maximum open cursors exceeded
Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.
Action: Modify the program to use fewer cursors. If this error occurs often,
shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.

And if you look at your "PRAGMA EXCEPTION_INIT(EOraDatumAuszerhalb, -1000); "
and you understand exception handling you will see why your trigger is raising SUCH EXCEPTION.

Cheers.

Carlos. Received on Tue Jan 17 2006 - 05:23:53 CST