Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Set Up Breakpoints in Debug Mode
(Continued from previous topic...)
How To Set Up Breakpoints in Debug Mode?
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:
- Right-click the procedure name: HELLO.
- Select Open. The source code of the stored procedure shows up in the code area.
- Set your mouse cursor to the "PUT_LINE('Hello world!');" statement.
- Click Debug menu.
- Select Toggle Breakpoint. You should see a red dot shows up in left margin of the statement
where the mouse cursor is. This red dot represents a breakpoint.
- Set another breakpoint at the "PUT_LINE('Welcome to PL/SQL!');" statement.
- Click the debug icon above the code area. The debug icon look like a bug. The Debug PL/SQL dialog shows up.
- Click OK. The debug session starts and stopped at the first breakpoint. You should see an array in left
margin indicating where the execution is stopped.
- Press F8 (Step Over). The execution continues for one statement.
- Press F9 (Resume). The execution continues to the end of the procedure.
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.
Welcome to PL/SQL!
Disconnecting from the database Local_XE.
Debugger disconnected from database.
(Continued on next topic...)
- What Is Oracle SQL Developer?
- What Operating Systems Are Supported by Oracle SQL Developer?
- How To Download Oracle SQL Developer?
- How To Install Oracle SQL Developer?
- How To Start Oracle SQL Developer?
- Is Oracel SQL Developer written in Java?
- How To Connect to a Local Oracle 10g XE Server?
- How To Connect to a Remote Server?
- How To Run SQL Statements with Oracle SQL Developer?
- How To Export Your Connection Information to a File?
- How To Run SQL*Plus Commands in SQL Developer?
- How To Work with Data Objects Interactively?
- How To Get a CREATE Statement for an Existing Table?
- How To Create a Table Interactively?
- How To Enter a New Row into a Table Interactively?
- What Is the Reports View in Oracle SQL Developer?
- How To Get a List of All Tables in the Database?
- How To Get a List of All User Accounts in the Database?
- How To Get a List of All Background Sessions in the Database?
- How To Create Your Own Reports in SQL Developer?
- How Many File Formats Are Supported to Export Data?
- How To Export Data to a CSV File?
- How To Export Data to an XML File?
- How To Create a Procedure Interactively?
- How To Run a Stored Procedure Interactively?
- How To Run Stored Procedures in Debug Mode?
- How To Assign Debug Privileges to a User?
- How To Set Up Breakpoints in Debug Mode?
- What Do You Think about Oracle SQL Developer?