Avatar of claghorn
claghorn

asked on 

oracle sql developer debugging

I use oracle sql developer 3.0 to debug a procedure. I compile for debug, set my breakpoint on a line and click the debug button. It produces a pl/sql block for the procedure which can be used for the debugging output but it comments out the DBMS_OUTPUT.PUT_LINE parts. It calls this legacy code. Why does it comment this out? How do I prevent it from doing so? Where is the setting for this so I can turn it off?

DECLARE
  IN_VAR NUMBER;
  OUT_RESULT NUMBER;
BEGIN
  IN_VAR := NULL;

  OUTPUT_PROC.PROCESSORDER(
    IN_VAR => IN_VAR,
    OUT_RESULT => OUT_RESULT
  );
  /* Legacy output: 
DBMS_OUTPUT.PUT_LINE('OUT_RESULT = ' || OUT_RESULT);
*/ 
  :OUT_RESULT := OUT_RESULT;
END;

Open in new window

Oracle Database

Avatar of undefined
Last Comment
OP_Zaharin

8/22/2022 - Mon