DBMS_WARNING.SET_WARNING_SETTING_STRING('ENABLE:ALL', 'SESSION'); : DBMS_WARNING « System Packages « Oracle PL / SQL






DBMS_WARNING.SET_WARNING_SETTING_STRING('ENABLE:ALL', 'SESSION');

  
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

1.SELECT DBMS_WARNING.GET_WARNING_SETTING_STRING() WARNING_LEVEL FROM dual