Shulou(Shulou.com)06/03 Report--

This article is to share with you about oracle stored procedures or function debugging process, the editor feels very practical, so share with you to learn, I hope you can learn something after reading this article, say no more, follow the editor to have a look.

Step 1: select debug mode

Find the function or stored procedure in the database that needs to be debugged under the functions package, then select the function (or stored procedure), right-click, appear as shown in the following figure, select the test function, and enter debugging mode.

Step 2: enter test data

Step 3: click to start the debugger

Step 4: enter the name of the variable to display

The variable name to be entered can be the input parameter name, or the variable name in the function or stored procedure. By observing the changes in the value of the variable, it is convenient for us to debug.

Step 5: click to debug step by step

Step 6: click step by step to debug and view the changes of variables

Step 7: repeat the first six steps until the debugging of the function or stored procedure is complete. The above is what the oracle stored procedure or function debugging process is like, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.