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