ALTER SESSION SET plsql_warnings = 'ENABLE:ALL'
Statement processed.
CREATE OR REPLACE PROCEDURE aftercompile
AUTHID DEFINER
IS
BEGIN
NULL;
END;
Procedure created.
SELECT plsql_warnings "From Session"
FROM all_plsql_object_settings
WHERE name = 'AFTERCOMPILE'
From Session |
---|
ENABLE:ALL |
ALTER PROCEDURE aftercompile COMPILE plsql_warnings = 'ERROR:ALL'
Procedure altered.
SELECT plsql_warnings "From Procedure Override"
FROM all_plsql_object_settings
WHERE name = 'AFTERCOMPILE'
From Procedure Override |
---|
ERROR:ALL |
CREATE OR REPLACE PROCEDURE aftercompile
AUTHID DEFINER
IS
BEGIN
NULL;
END;
Procedure created.
SELECT plsql_warnings "Compile From Source"
FROM all_plsql_object_settings
WHERE name = 'AFTERCOMPILE'
Compile From Source |
---|
ENABLE:ALL |
ALTER PROCEDURE aftercompile COMPILE plsql_warnings = 'ERROR:ALL'
Procedure altered.
SELECT plsql_warnings "Back to Procedure Override"
FROM all_plsql_object_settings
WHERE name = 'AFTERCOMPILE'
Back to Procedure Override |
---|
ERROR:ALL |
ALTER SESSION SET plsql_warnings = 'ENABLE:ALL'
Statement processed.
ALTER PROCEDURE aftercompile COMPILE REUSE SETTINGS
Procedure altered.
SELECT plsql_warnings "Session Change No Impact with REUSE SETTINGS"
FROM all_plsql_object_settings
WHERE name = 'AFTERCOMPILE'
Session Change No Impact with REUSE SETTINGS |
---|
ERROR:ALL |