We help IT Professionals succeed at work.
Get Started

oracle sql developer debugging

claghorn
claghorn asked
on
1,145 Views
Last Modified: 2012-08-13
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

Comment
Watch Question
Top Expert 2011
Commented:
This problem has been solved!
Unlock 2 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE