Errors raised in PL/SQL blocks, procedures, triggers and bind variables, and how to read the error stack.
ORA-06502
PL/SQL: value or conversion errorA value did not fit a PL/SQL variable: string too long, too many digits, bad conversion or NULL into NOT NULL.
ORA-06512
at line (PL/SQL error stack)A stack line, not the real error: read the error above it and the unit and line it names.
ORA-01403
no data foundA SELECT INTO returned no rows (NO_DATA_FOUND).
ORA-01422
exact fetch returned more than the requested number of rowsA SELECT INTO or RETURNING INTO returned more than one row (TOO_MANY_ROWS).
ORA-01008
value for bind variable placeholder was not providedA statement ran without a value for one of its bind placeholders (USING clause, repeated placeholder, driver binds).
ORA-06550
line, column: (PL/SQL compilation error)A PL/SQL block failed to compile; the PLS- error on the next line says why.
ORA-04091
table is mutating, trigger/function may not see itA row trigger or a function called from DML read or changed the table being modified.
ORA-20000
user-defined error (RAISE_APPLICATION_ERROR, ORA-20000 to ORA-20999)An application error raised on purpose with RAISE_APPLICATION_ERROR; the message is the application's.
PLS-00201
identifier must be declaredA name could not be resolved: misspelt, out of scope, missing, or no direct privilege (roles do not count in stored code).
PLS-00103
Encountered the symbol ... when expecting one of the followingA PL/SQL syntax error: a missing semicolon, END or THEN, a reserved word as a name, or DDL in a block.
PLS-00306
wrong number or types of arguments in callA call matches no declaration of the subprogram: wrong argument count, wrong types or no matching overload.
No errors in this category match your search. Search the whole library.