How do I debug in Toad?

1.	How do I debug in Toad?
Answer» You can debug the stored procedure in TOAD by FOLLOWING the below steps:- Step 1: -First load your Procedure in the Toad EDITOR. Step 2: -Now put debug point on the line where you want to debug. Now see the first screenshot. Step 3: -Then right click on the editor Execute->Execute PLSQL(DEBUGGER). Now see the second screenshot. Step 4: - A window will open up, and you have to select the procedure from the left-hand side and pass the parameters for that procedure and then click Execute. Now see the third screenshot. Step 5: - Start your DEBUGGING check now Debug-->Step Over...Add Watch etc. This is one of the most asked TOAD interview questions.

Answer»

You can debug the stored procedure in TOAD by FOLLOWING the below steps:-

Step 1: -First load your Procedure in the Toad EDITOR.
Step 2: -Now put debug point on the line where you want to debug. Now see the first screenshot.
Step 3: -Then right click on the editor Execute->Execute PLSQL(DEBUGGER). Now see the second screenshot.
Step 4: - A window will open up, and you have to select the procedure from the left-hand side and pass the parameters for that procedure and then click Execute. Now see the third screenshot.
Step 5: - Start your DEBUGGING check now Debug-->Step Over...Add Watch etc.

This is one of the most asked TOAD interview questions.

Discussion