ALTER SESSION SET plsql_optimize_level = 1 Statement processed.
CREATE OR REPLACE PROCEDURE compute_intensive
AUTHID DEFINER
IS
BEGIN
$IF $$plsql_optimize_level < 2
$THEN
$ERROR 'compute_intensive must be compiled with maximum optimization!' $END
$END
NULL;
END compute_intensive; Errors: PROCEDURE COMPUTE_INTENSIVE Line: 7 PLS-00179: $ERROR: compute_intensive must be compiled with maximum optimization!More Details: https://docs.oracle.com/error-help/db/ora-24344
ALTER SESSION SET plsql_optimize_level = 3 Statement processed.
CREATE OR REPLACE PROCEDURE compute_intensive
AUTHID DEFINER
IS
BEGIN
$IF $$plsql_optimize_level < 2
$THEN
$ERROR 'compute_intensive must be compiled with maximum optimization!' $END
$END
NULL;
END compute_intensive; Procedure created.