Oracle PL/SQL/System Packages/DBMS WARNING

Материал из 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>



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>
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Packages/DBMS_WARNING&oldid=1272»