cc_debug_trace.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 13 行

ALTER SESSION SET PLSQL_CCFLAGS = 'oe_debug:true, oe_trace_level:10';

CREATE OR REPLACE PROCEDURE calculate_totals
IS
BEGIN
$IF $$oe_debug AND $$oe_trace_level >= 5
$THEN
   DBMS_OUTPUT.PUT_LINE ('Tracing at level 5 or higher');
$END            
   NULL;
END calculate_totals;
/