|Oracle Exception Name
violation. This means you've used constraints or indexes
to restrict entry of duplicate records, but then gone and
tried to insert a duplicate record, at least as far as the
record's keys are concerned.
occurred while waiting on a resource. This usually means
that there was some sort of unusual termination of an
||The remote portion
of a transaction has rolled back.
||The cursor does
not yet exist. The cursor must be OPENed before any FETCH
cursor or CLOSE cursor operation.
||You are not logged
||This exception is
returned when your select statement returned zero rows.
NOTE that an update statement will not throw this
exception. Instead, query the sql%notfound and the
sql%rowcount variables to determine the result of your
||A SELECT ... INTO
query matched more than one row. That is, a select that
was supposed to return a single row returned more than one
||Divide by zero
occurs when you try to convert a string to a number, and
the string doesn't contain a valid number.
||Occurs when PL/SQL
itself has run out of memory, it needs more than is
available, or if there was some sort of corruption error.
is thrown when the PL/SQL interpreter itself encounters
an error while processing your code.
||You tried to
perform an operation and there was a error on a
conversion, truncation, or invalid constraining of numeric
or character data.
||You'll get this
exception when a host cursor variable and the PL/SQL
cursor variable you're fetching into have incompatible
||You attempted to
open a cursor that was already open
||Attempt to assign
values to the attributes of a NULL object
||An attempt was
made to apply collection methods other than EXISTS to a
NULL PL/SQL table or varray
|Occurs when an attempt to
call a MEMBER method is made on a null instance.
|Means you tried to index
off the end of a varray or nexted table. The index you
used was higher than the number of elements in the
|Reference to a nested table
or varray index outside the declared range -- such as an
index of -1.
|This occurs when the
character string used to represent the rowID fails because
the character string doesn't represent a valid row ID.