Oracle has these common built-in Boolean values for the exception
clause.
It's easy to use the built-in values with the
PL/SQL exceptions clause.
Also see, these
notes on creating a custom exception in PL/SQL.
For working examples of the exceptions clause see the download from
the book
Easy
PL/SQL Programming and the code depot in the great book
PL/SQL Tuning Secrets by Dr. Timothy Hall.
|
access_into_null
|
ORA-06530
|
|
case_not_found
|
ORA-06592
|
|
collection_is_null
|
ORA-06531
|
|
cursor_already_open
|
ORA-06511
|
|
dup_val_on_index
|
ORA-00001
|
|
invalid_cursor
|
ORA-01001
|
|
invalid_number
|
ORA-01722
|
|
login_denied
|
ORA-01017
|
|
no_data_found
|
ORA-01403
|
|
not_logged_on
|
ORA-01012
|
|
program_error
|
ORA-06501
|
|
rowtype_mismatch
|
ORA-06504
|
|
self_is_null
|
ORA-30625
|
|
storage_error
|
ORA-06500
|
|
subscript_beyond_count
|
ORA-06533
|
|
subscript_outside_limit
|
ORA-06532
|
|
sys_invalid_rowid
|
ORA-01410
|
|
timeout_on_resource
|
ORA-00051
|
|
too_many_rows
|
ORA-01422
|
|
value_error
|
ORA-06502
|
|
zero_divide
|
ORA-01476
|
