For some reason when using the raise_application_error() function in my code, I can never remember the valid numeric values. The answer is a simple mnemonic that’s in the title of this blog post.

The valid range for an error is -20000 to -20999 inclusive, which…hey! The maximum value is just one less than the error message you’ve got. So! Remember:

Valid Range: ORA-20000 through ORA-20999.

ORA-21000 means “you’ve gone too far.”

Hope this helps!

Free Oracle SQL Tuning Guide

Checkout my FREE guide, 7 SQL Tuning Secrets You Can Use Immediately, Even If You’ve Never Tuned a Query In Your Life!

Get it here:

7 SQL Tuning Secrets You can Use Immediately, Even If You've Never Tuned A Query In Your Life

Leave a Reply

Your email address will not be published. Required fields are marked *