How to debug stored procedure/function in TOAD

I studied how to debug the Stored Procedure or function under Toad and saw the corresponding menu under Toad before, but I never knew how to use it. For details, please refer to the article:
Debugging PL/SQL, now available for everyone!

Here’s a case of how debugging in Toad works:


The test code for this Case:
CREATE OR REPLACE PROCEDURE APPS.swapn (num_one IN OUT NUMBER, num_two IN OUT NUMBER) IS
temp_num NUMBER;
BEGIN
temp_num := num_one;
num_one := num_two;
num_two := temp_num ;
END;


On the breakpoint


Be sure to compile your Procedure
first


Run in Debug (most of the buttons in the Debug menu are grayed out if you don’t compile the Stored Procedure)


Before is debugged, set the values of input parameters

will stop at the break point, you can see the Watches output window, variable value changes





Read More: