Sunday, April 20, 2008

ORA-21000:error number argument to raise_application_error is out of range

ORA-21000:error number argument to raise_application_error of stringstring is out of range

Cause:An attempt was made to specify a number not in the allowed range.

Action:Use an error number in the range of -20000 to -20999, inclusive.

ORA-21000: "error number argument to raise_application_error of 0 is out of range":

The PL/SQL RAISE_APPLICATION_ERROR procedure has been called with an error code of 0. The only valid error codes are 20000 to 20099.

The usualy cause for a value of 0 being used is that a program has failed to set amn error variable correctly, e.g. it has called an exception but not set the variable.

No comments: