Plsql Developer Debug

If you want to see the execution of a stored procedure or function, you can use debug mode. Plsql Developer provides the debug function, taking the function as an example:

1. Find the function you want to debug, then right click----Select "Add Debug Information",

2. Right-click function, select Test to enter the debug mode window.

3. In the Test window, start debugger (F9) and click Run (ctrl+r) to execute directly, or click Step Into (CTRL + N) to step through.
If you step in, you can see the assignment of the runtime by placing the mouse over the variable. Right-click on a variable to use the eclipse-like watch feature