Iamlaosong
Alas, the real soil, used toad, has been using dbms_output.put_line debugging stored procedures, only feel inconvenient, with PL/SQL developer, or use this method, online search, just know can be single-step debugging. Learn to use PL/SQL developer debugging features for writing complex stored procedures, packages, funtion ... Very helpful, the analysis of the results of the execution of the stored procedure is also useful, and now the steps are summarized below (many online information, not):
1, the first is to write stored procedures, compile error;
2, add debug information. To be able to step through the stored procedure, you need to add debug information for the package it is in, right-click the name of the stored procedure you want to debug, select [Add debug Information] in the popup menu, and add debug information to the package body;
3, choose the name of the stored procedure to debug, right-click, select [Test] in the pop-up menu, go to the Test window, test window in order to test the stored procedure automatically generated code, of course, you can also add and modify the code yourself, automatically generated code is enough. Parameters are required to enter parameter values in the following parameter input table.
4, start debugging. Click the Start icon on the toolbar or press F9 to enter debug mode, the subsequent debugging process is the same as we are familiar with the debugging process (the following is a menu or a section of the tool bar debugging function):
Run (CTRL+R) runs at full speed and stops at the breakpoint;
Step Into (CTRL + N) performs a step, if it is called process, enters the sub-process;
Step Over (Ctrl+o) executes a step, no matter what the statement;
Step Out (CTRL+T) executes the process until it exits from the process to the upper level;
。。。。。。
5, the debugging process can set breakpoints (click on the left gray margin of the breakpoint statement, a red fork is a breakpoint, click again can be canceled), you can see the value of the variable in the process (when the mouse points to the variable, the system automatically shows the value of the variable).
if it is not possible to step through or set a breakpoint, it may be the second step above [add debug information] did not do.
Debug Oracle stored procedures in PL/SQL developer
