SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AFTER SERVERERROR trigger exceptions

GusoraJun 14 2005 — edited Jun 14 2005

AFTER SERVERERROR triggers fire after an Oracle error is raised, unless the error is one of the following:

ORA-00600 Oracle internal error (understandable)
ORA-01034 Oracle not available (understandable)
ORA-01403 No data found
ORA-01422 Exact fetch returns more than requested number of rows (too many rows)
ORA-01423 Error encountered while checking for extra rows in an exact fetch
ORA-04030 Out-of-process memory when trying to allocate N bytes

Anyone know why these errors are excluded?

Gus

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2005

Added on Jun 14 2005

1 comment

736 views