如何在Toad中调试存储过程?

I have Oracle 10g installed and there is a package which has a number of cursors and procedures, how do I debug one of these procedures or cursors. Can you please provide steps for that? I ran a Google search but did not find anything specifying how to debug a particular procedure from a package.

我已经安装了Oracle 10g，并且有一个包包含许多游标和过程，我如何调试这些过程或游标中的一个。你能提供一些步骤吗?我执行了谷歌搜索，但是没有找到任何指定如何从包中调试特定过程的内容。

2 个解决方案

#1

Basic Steps to Debug a Procedure in Toad

在Toad中调试过程的基本步骤

1. Load your Procedure in Toad Editor.
2. 在Toad Editor中加载您的过程。
3. Put debug point on the line where you want to debug.See the first screenshot.
4. 将调试点放在要调试的行上。看到第一个截图。
5. Right click on the editor Execute->Execute PLSQL(Debugger).See the second screeshot.
6. 右键单击编辑器Execute——>执行PLSQL(调试器)。看到第二个screeshot。
7. A window opens up,you need to select the procedure from the left side and pass parameters for that procedure and then click Execute.See the third screenshot.
8. 打开一个窗口，您需要从左侧选择过程，并传递该过程的参数，然后单击Execute。看到第三个截图。
9. Now start your debugging check Debug-->Step Over...Add Watch etc.
10. 现在开始调试检查调试——>步骤……添加表等。

Reference:Toad Debugger

参考:蟾蜍调试器

#2

Open a PL/SQL object in the Editor.

在编辑器中打开一个PL/SQL对象。

Click on the main toolbar or select Session | Toggle Compiling with Debug. This enables debugging.

单击主工具栏或选择会话|切换编译与调试。这使得调试。

Compile the object on the database.

编译数据库上的对象。

Select one of the following options on the Execute toolbar to begin debugging: Execute PL/SQL with debugger () Step over Step into Run to cursor

选择执行工具栏上的下列选项之一开始调试:执行PL/SQL和调试器()步骤，以运行到游标。