I agree to Idea Debug in simple plsql script
Voting Disabled

29 votes

I disagree to Idea Debug in simple plsql script

Rank27

Idea#166

This idea is active.
Debug »

Debug in simple plsql script

Implemente debug in single plsql script.

In this moment to use debug, is necessary create one procedure like "lixo", to execute the debug

Submitted by 4 years ago

Comments (2)

  1. Having to create a procedure, or utilize Toad's popup PL/SQL debugger window is obnoxious. Since the popup window is essentially the same thing as an anonymous PL/SQL block, why can an anonymous block in an editor window not be debugged?

    4 years ago
    0 Agreed
    0 Disagreed
  2. Moderator

    Remember that in the DBMS Debugger that you're not debugging the anonymous block, you're debugging the procedure called by the anonymous block. The anonymous block is used to set the conditions for execution as well as being able to post process any results from the procedure execution. We are simply executing the code via the DBMS_DEBUG API provided by Oracle.

    You can also turn off the "obnoxious" parameters window in Options -> Execute/Compile -> Behavior -> Always open parameters window. This will only prompt you for parameters if they are needed to execute the procedure.

    4 years ago
    0 Agreed
    0 Disagreed