Collections:
Set Up Breakpoints in Debug Mode in Oracle
How To Set Up Breakpoints in Debug Mode in Oracle?
✍: FYIcenter.com
To debug a stored procedure, you need to set breakpoints at different statements in the code block, so that execution will be stopped at the statement marked with a breakpoint. When execution is stopped, you can then investigate different variables to see their current values. The tutorial below shows you how to set up breakpoints:
You should see the following in the Debugging Log area:
Connecting to the database Local_XE. Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '127.0.0.1', '3685' ) Debugger accepted connection from database on port 3685. Processing 59 classes that have already been prepared... Finished processing prepared classes. Source breakpoint occurred at line 3 of HELLO.pls. Source breakpoint occurred at line 4 of HELLO.pls. Hello world! Welcome to PL/SQL! Process exited. Disconnecting from the database Local_XE. Debugger disconnected from database.
⇒ What Do You Think about Oracle SQL Developer in Oracle
⇐ Assign Debug Privilege to a User in Oracle
2018-12-26, 1809🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...