Collections:
Run Stored Procedures in Debug Mode in Oracle
How To Run Stored Procedures in Debug Mode in Oracle?
✍: FYIcenter.com
If have an existing stored procedure and you want to debug it interactively, you can use the debug feature provided in SQL Developer. The following exercise shows you how to start the debug mode:
You may get the following errors. Read the next tutorial on how to fix the errors.
Connecting to the database Local_XE. Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP(...) ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68 ORA-06512: at line 1 This session requires DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges. Process exited. Disconnecting from the database Local_XE.
2019-01-12, 958👍, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want t...
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...