Debugging of Oracle Stored procedures

In the work summary sometimes the program calls the stored procedure to implement certain functions, because in this case, the speed is faster. So it's very important to learn how to debug stored procedures.

First of all, open plsql development first introduction, the software's various windows is used for what.

, this is the Plsql tool on the left side of the window, the role of each window, where we discuss how to perform the debugging functions of Oracle's stored procedures in Plsql. So mostly see 2 and 3.

2. Is the package folder, which holds the stored procedure, 3 is the type of Oracle, is called by the stored procedure.

First we find the code that calls the stored procedure in the Java program, which tells us the name of the calling stored procedure and the function that called the stored procedure.

First find the stored procedure, and then you can see in the right window which functions, if you want to see the specific function of the code, click the button to see the specific stored procedure of the Code of the function.

If you want to test, then select the function for the stored procedure, then right----the test.

You can also break points,

After you hit the breakpoint, you can start the test. For example, fill in the appropriate parameters or write the appropriate script.

If you want to jump directly to the breakpoint, then click the Start Debugging button, then click on Button 1, then the program will jump directly to the breakpoint.

At the click of button 2, the program will step down, you can hover the mouse over the button, so that the goods can see the value of the corresponding variable.

This will allow you to see exactly which step was wrong. (because there is an exception block in the stored procedure, if you jump to a block, then the error occurs in the previous step)

Debugging of Oracle Stored procedures