Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Run Stored Procedures in Debug Mode

By: FYIcenter.com

(Continued from previous topic...)

How To Run Stored Procedures in Debug Mode?

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.

(Continued on next topic...)

  1. What Is Oracle SQL Developer?
  2. What Operating Systems Are Supported by Oracle SQL Developer?
  3. How To Download Oracle SQL Developer?
  4. How To Install Oracle SQL Developer?
  5. How To Start Oracle SQL Developer?
  6. Is Oracel SQL Developer written in Java?
  7. How To Connect to a Local Oracle 10g XE Server?
  8. How To Connect to a Remote Server?
  9. How To Run SQL Statements with Oracle SQL Developer?
  10. How To Export Your Connection Information to a File?
  11. How To Run SQL*Plus Commands in SQL Developer?
  12. How To Work with Data Objects Interactively?
  13. How To Get a CREATE Statement for an Existing Table?
  14. How To Create a Table Interactively?
  15. How To Enter a New Row into a Table Interactively?
  16. What Is the Reports View in Oracle SQL Developer?
  17. How To Get a List of All Tables in the Database?
  18. How To Get a List of All User Accounts in the Database?
  19. How To Get a List of All Background Sessions in the Database?
  20. How To Create Your Own Reports in SQL Developer?
  21. How Many File Formats Are Supported to Export Data?
  22. How To Export Data to a CSV File?
  23. How To Export Data to an XML File?
  24. How To Create a Procedure Interactively?
  25. How To Run a Stored Procedure Interactively?
  26. How To Run Stored Procedures in Debug Mode?
  27. How To Assign Debug Privileges to a User?
  28. How To Set Up Breakpoints in Debug Mode?
  29. What Do You Think about Oracle SQL Developer?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...