RESTRICT_REFERENCES Pragma → statement is parsed). To check for violations of the rules, you can use the pragma (compiler directive … ) RESTRICT_REFERENCES. The pragma asserts that a function does not read and/or write database tables and

EXCEPTION_INIT Pragma → The pragma EXCEPTION_INIT associates an exception name with an Oracle error number. That lets you … OTHERS handler. For more information, see \"Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT\".

Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT → OTHERS handler or the pragma EXCEPTION_INIT. A pragma is a compiler directive that is processed at … compile time, not at run time. In PL/SQL, the pragma EXCEPTION_INIT tells the compiler to associate … , the one on top is the one that you can trap and handle. You code the pragma EXCEPTION_INIT in the … declarative