Pages

Saturday 17 September 2016

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

Cause:
An attempt was made to specify a number not in the allowed 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 usually cause for a value of 0 being used is that a program has failed to set an error variable correctly, e.g. it has called an exception but not set the variable.

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

No comments:

Post a Comment

Code Review

 SOLID Principles S – Single Responsibility Principle There should never be more than one reason for a class to change. O – Open-Closed Prin...