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.


lee woo said...

The best argument against democracy is a five-minute conversation with the average voter. See the link below for more info.


Silvia Jacinto said...

Time is gold. We should treasure every second of it so that in time we will not regret anything because we only live ones.I have read your article and i was glad and inspired. Thanks for it, Cheers!
Visit my site if you have time, Enjoy.

sarah lee said...

I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.