Oracle DB programming

Setting compile time variable (tracing pragma example)

Posted

alter package pkg_my_package compile body plsql_ccflags = ‘debug_code:true’ reuse settings;

and in the package body:

IF $$debug_code
THEN
….
END IF;