How To Run Stored Procedures in Debug Mode

Q

How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer

✍: FYIcenter.com

A

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:

Open you connection name, like Local_XE.
Open Procedures.
Right-click the procedure name: HELLO.
Select Debug. The Debug PL/SQL window shows up. SQL Developer creates a simple anonymous code block for you to run the stored procedure.
Click OK.

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.

2007-04-28, 7200👍, 0💬

How To Export Data to an XML File
How To Export Data to an XML File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to export data from a table to a file in XML format, you can use the following steps: Right-click the table name, EMPLOYEES, in the object tree view. Select Export. Select XML. The Export Data wind... 2007-04-27, 8148👍, 0💬

How To Run Stored Procedures in Debug Mode
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer 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: Open... 2007-04-28, 7201👍, 0💬

How To Set Up Breakpoints in Debug Mode
How To Set Up Breakpoints in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer 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,... 2007-04-28, 6915👍, 0💬

How To Assign Debug Privileges to a User
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges: Connect to the default dat... 2007-04-28, 6176👍, 0💬

How To Run a Stored Procedure Interactively
How To Run a Stored Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If have an existing stored procedure and you want to run it interactively, the tutorial steps listed below will help you out: Open you connection name, like Local_XE. Open Procedures. Right-click the... 2007-04-28, 5057👍, 0💬

How Many File Formats Are Supported to Export Data
How Many File Formats Are Supported to Export Data? - Oracle DBA FAQ - Introduction to Oracle SQL Developer Oracle SQL Developer can allow to export table data into files in the following formats: TXT - Tab delimited fields file format. CSV - Comma Separated Values (CSV) file format. LOADER - File f... 2007-04-27, 4978👍, 0💬

How To Create a Procedure Interactively
How To Create a Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure win... 2007-04-28, 4701👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iS... 2007-04-28, 4521👍, 0💬

What Do You Think about Oracle SQL Developer
What Do You Think about Oracle SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To conclude this introductory FAQ collection, you should think about Oracle SQL Developer in comparison with other client tools like SQL*Plus and Oracle Web interface. SQL Developer is definitely be... 2007-04-28, 4473👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.