Search notes:

Oracle PL/SQL: Errors and warnings

Three categories of warnings

Severe
Informational
Performance
Which of these warnings are reported is controlled by the value of the init parameter plsql_warnings.

Some Errors

PLS-00103: Encountered the symbol "…" when expecting one of the following: …
PLS-00174: a static boolean expression must be used
PLS-00201: identifier … must be declared
PLS-00215: String length constraints must be in range (1 .. 32767)
PLS-00157: Only schema-level programs allow AUTHID

Some warnings

PLW-05004: identifier … is also declared in STANDARD or is a SQL builtin
PLW-05005: subprogram … returns without value at line …
PLW-05011: pragma INLINE for procedure '…' does not apply to any calls
PLW-05018: unit … omitted optional AUTHID clause; default value DEFINER used
PLW-06002: Unreachable code
PLW-06003: unknown inquiry directive '$$…'
PLW-06006: uncalled procedure "…" is removed.
PLW-06009: procedure "…" OTHERS handler does not end in RAISE or RAISE_APPLICATION_ERROR
PLW-06010: keyword "…" used as a defined name
PLW-06026: package specification exposes global variable …
PLW-07203: parameter '…' may benefit from use of the NOCOPY compiler hint
PLW-07204: conversion away from column type may result in sub-optimal query plan
PLW-07206: analysis suggests that the assignment to '…' may be unnecessary

See also

Errors in PL/SQL can be queried from all_errors.
The dbms_utility procedures
The column PLSQL_WARNINGS in dba_plsql_object_settings

Index