CREATE OR REPLACE PROCEDURE show_compilation_parameters
AUTHID DEFINER
IS
BEGIN
DBMS_OUTPUT.put_line ('$$PLSCOPE_SETTINGS = ' || $$plscope_settings);
DBMS_OUTPUT.put_line ('$$PLSQL_CCFLAGS = ' || $$plsql_ccflags);
DBMS_OUTPUT.put_line ('$$PLSQL_CODE_TYPE = ' || $$plsql_code_type);
DBMS_OUTPUT.put_line ('$$PLSQL_OPTIMIZE_LEVEL = ' || $$plsql_optimize_level);
DBMS_OUTPUT.put_line ('$$PLSQL_WARNINGS = ' || $$plsql_warnings);
DBMS_OUTPUT.put_line ('$$NLS_LENGTH_SEMANTICS = ' || $$nls_length_semantics);
END; Procedure created.
BEGIN
show_compilation_parameters;
END; Statement processed.
$$PLSCOPE_SETTINGS = IDENTIFIERS:NONE
$$PLSQL_CCFLAGS =
$$PLSQL_CODE_TYPE = INTERPRETED
$$PLSQL_OPTIMIZE_LEVEL = 2
$$PLSQL_WARNINGS = DISABLE:ALL
$$NLS_LENGTH_SEMANTICS = BYTE
ALTER SESSION SET plsql_warnings = 'enable:all' Statement processed.
ALTER SESSION SET plsql_code_type = native Statement processed.
ALTER SESSION SET plsql_ccflags = 'Flag1:10, Flag2:true' Statement processed.
ALTER PROCEDURE show_compilation_parameters COMPILE Procedure altered.
BEGIN
show_compilation_parameters;
END; Statement processed.
$$PLSCOPE_SETTINGS = IDENTIFIERS:NONE
$$PLSQL_CCFLAGS = Flag1:10, Flag2:true
$$PLSQL_CODE_TYPE = NATIVE
$$PLSQL_OPTIMIZE_LEVEL = 2
$$PLSQL_WARNINGS = ENABLE:ALL
$$NLS_LENGTH_SEMANTICS = BYTE
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 |
|---|