Question

a.     Make provision to handle any kind of unknown ORACLE error using a ORACLE predefined error handler by displaying appropriate message”ORACLE/Unknown error! – call support stuff”

Answer 1

ALTER PROCEDURE loc_var
  COMPILE PLSQL_WARNINGS=”ORACLE/Unknown error! – call support stuff”
  REUSE SETTINGS;