Shulou(Shulou.com)05/31 Report--

This article mainly introduces Oracle how to debug stored procedures, the article is very detailed, has a certain reference value, interested friends must read it!

One key step of debugging

1. Right-click the stored procedure to debug, and select Edit to debug. The screenshot is as follows:

2. Click Ladybug, and the debug window pops up. The screenshot is as follows:

3. Enter the employee ID of 7839 and click OK to debug. The screenshot is as follows:

4. The screenshot shows that the permissions are not enough, and the permissions of the scott user need to be added.

5. Add permission statement as follows:

SQL > show userUSER enter the password for "SCOTT" SQL > connect system: connected. SQL > show userUSER is "SYSTEM" SQL > grant DEBUG CONNECT SESSION, and DEBUG ANY PROCEDURE to scott; authorization is successful.

6. Debug again, and the program stays at the breakpoint. The screenshot is as follows:

7. If you want to view the value of psal, you can right-click the variable and select "Monitor" to view the value.

8. F8 runs the program step by step.

9. Click the red box of the toolbar to finish debugging.

2 matters needing attention

It is recommended to use local debugging rather than remote debugging.

These are all the contents of the article "how to debug stored procedures in Oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to 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.