troubleshooting Question

oracle sql developer debugging

Avatar of claghorn
claghorn asked on
Oracle Database
6 Comments2 Solutions1152 ViewsLast Modified:
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

ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros