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


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





Read More:
- Debugging mode of MATLAB: dbstop if error
- Problem solving – vs debugging window flash solution
- error: a label can only be part of a statement and a declaration is not a statement (How to Fix)
- Arithmetic overflow error converting numeric to data type numeric.
- About starting the service, you always get stuck in com. Alibaba. Druid. Pool. Druiddatasource | {datasource-1} initiated
- Vs error: there is an error in the script of the current page
- CIN in C + + cin.get ()、 cin.getline (), getline(), gets() function
- Solution to the problem that the toolbar menu button cannot be clicked
- IntelliJ idea debugging Java 8 stream
- Vue: How to prompt this .$message
- The principle of deformable convolution
- Getting started with jmu-java-m01-scanner
- Memory configuration of BIOS combat
- Error converting data type nvarchar to datetime
- In C + + cin.getline The difference between () and getline () functions
- Some solutions to the problem of windows flashback after vs running
- Can’t initialize OCI. Error – 1 appears in toad for Oracle
- A first chance exception of type ‘ System.NullReferenceException ‘when occurred, you did encounter a bug
- Failed to connect to remote VM. Connection reused. Connection reused: Connect