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, 1770🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...