Exception name cause handler name
No
data found
when select into no_data_found
statement
fails to
return any
records
Too many rows when select into
stmt
too_many_rows
returns more than 1 row
Unique when unique cons is dup_val_on_index
Constraint violated Violated
Invalid number when non numeric
value
invalid_number
is
specified for number
column
during dml
Value error when non
numeric value value_error
is
assigned to number
type
variable.
Invalid cursor when we
refer to invalid_cursor
cursor that has
not been
declared
or that
has been
closed
Cursor already when we open a
cursor_already_open
Open cursor
that is
already
open
Zero divide when we
divide a number zero_divide
by zero
Case not found when case
statement
case_not_found
does not
find the
specified
condition
Program error when
pl/sql engine program_error
fails
Storage error when server has no
storage_error
memory
to execute
pl/sql
code
