All About PL/SQL Compiler Settings

View All Scripts Login to Run Script

Statement 1

ALTER SESSION SET plsql_warnings = 'ENABLE:ALL'

Statement processed.

Statement 2

CREATE OR REPLACE PROCEDURE aftercompile 
   AUTHID DEFINER 
IS 
BEGIN 
   NULL; 
END;

Procedure created.

Statement 3

SELECT plsql_warnings "From Session" 
  FROM all_plsql_object_settings 
 WHERE name = 'AFTERCOMPILE'


From Session
ENABLE:ALL

From Session
ENABLE:ALL

Statement 4

ALTER PROCEDURE aftercompile COMPILE plsql_warnings = 'ERROR:ALL'

Procedure altered.

Statement 5

SELECT plsql_warnings "From Procedure Override" 
  FROM all_plsql_object_settings 
 WHERE name = 'AFTERCOMPILE'


From Procedure Override
ERROR:ALL

From Procedure Override
ERROR:ALL

Statement 6

CREATE OR REPLACE PROCEDURE aftercompile 
   AUTHID DEFINER 
IS 
BEGIN 
   NULL; 
END;

Procedure created.

Statement 7

SELECT plsql_warnings "Compile From Source" 
  FROM all_plsql_object_settings 
 WHERE name = 'AFTERCOMPILE'


Compile From Source
ENABLE:ALL

Compile From Source
ENABLE:ALL

Statement 8

ALTER PROCEDURE aftercompile COMPILE plsql_warnings = 'ERROR:ALL'

Procedure altered.

Statement 9

SELECT plsql_warnings "Back to Procedure Override" 
  FROM all_plsql_object_settings 
 WHERE name = 'AFTERCOMPILE'


Back to Procedure Override
ERROR:ALL

Back to Procedure Override
ERROR:ALL

Statement 10

ALTER SESSION SET plsql_warnings = 'ENABLE:ALL'

Statement processed.

Statement 11

ALTER PROCEDURE aftercompile COMPILE REUSE SETTINGS

Procedure altered.

Statement 12

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

Session Change No Impact with REUSE SETTINGS
ERROR:ALL

Additional Information