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.
⇒ Assign Debug Privilege to a User in Oracle
⇐ Run Stored Procedures Interactively in Oracle
2019-01-12, 3243🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...