Brief Introduction to Oracle Stored Procedure debugging

PLSQL provides the Oracle Stored Procedure debugging function to help you complete the pre-compilation and testing of stored procedures. Right-click the stored procedure to be debugged and select

PL/SQL provides the Oracle Stored Procedure debugging function to help you complete the pre-compilation and testing of stored procedures. Right-click the stored procedure to be debugged and select

PL/SQL provides the Oracle Stored Procedure debugging function to help you complete the pre-compilation and testing of stored procedures.

Right-click the stored procedure to be debugged and choose TEST

If you need to view the variables, debugging is required. Right-click the menu and choose Add debug information.

Start debugger (F9) start our test, Run (Ctrl + R)

Enter the variables we want to view in the varible List at any time.

Others:

Step into (Ctrl + N): One-Step debugging to go to the next Step

Step over (Ctrl + O): end the statement

Step out (Ctrl + T): jump out of this Process

Run to next exception: Enter the next Breakpoint

Toggle Breakpoint: The cursor points to a row, Ctrl + B; or the row number edge in the cursor