SELECT DBMS_WARNING.GET_WARNING_SETTING_STRING() WARNING_LEVEL FROM dual
SQL>
SQL> SET SERVEROUTPUT ON ESCAPE OFF
SQL>
SQL>
SQL> CALL DBMS_WARNING.SET_WARNING_SETTING_STRING('ENABLE:ALL', 'SESSION');
Call completed.
SQL>
SQL> SELECT DBMS_WARNING.GET_WARNING_SETTING_STRING() WARNING_LEVEL FROM dual;
WARNING_LEVEL
--------------------------------------------------------------------------------
ENABLE:ALL
1 row selected.
SQL>
SQL>
SQL> ALTER PROCEDURE compile_warning COMPILE;
Warning: Procedure altered with compilation errors.
SQL>
SQL>
SQL> SHOW ERRORS
Errors for PROCEDURE COMPILE_WARNING:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/31 PL/SQL: SQL Statement ignored
4/49 PL/SQL: ORA-00942: table or view does not exist
SQL>
Related examples in the same category