How to efficiently debug an Oracle stored procedure, especially a parent-child mesh call stored procedure
1. Set breakpoints at Oracle stored procedure where breakpoints need to be set
How to set breakpoints: Click a line at the beginning of a row of Oracle stored procedures to display a
Middle toA small red circle filled with white forks.
How to cancel a breakpoint: click between
2, and then
3, press the Magnifier icon (start Debugger) or click the shortcut key F9 or open the
menu Debug-->start
4, and then click
pl/sql Developer Test window toolbar
1,step into Single-step debugging, popular speaking is to keep track of the details, similar to
2,step over parallel debugging, can be understood as a and b stored procedures are parent-child call relationship, it will not
runs to the B-stored procedure, but a runs directly to the following generation
code with a-peer
3,step out of step into, that is, from a child stored procedure jumps to its parent stored procedure
4,run to next exception run to the next exception, run the code where the stored procedure error occurs directly,
This feature I don't have a deep understanding of
How to run a breakpoint on the Oracle stored procedure in PL/SQL Developer 7