Posts tagged ‘dbms_debug’

  |  
February 4, 2011

Debug Mode is disabled in Oracle 10g

Sometimes you may find debugging icons in your PL/SQL development tools, such as TOAD or Sql developer,  appearing in gray. That may be caused by the following factors:

  • your IDE is not licensed with debugging option;
  • the user who was going to run debugger is not granted with necessary privileges:
    • grant debug connect session to user
    • grant debug any procedure to user
  • the dbms_debug package has not been created in database, in this case, run $ORACLE_HOME/rdbms/admin/dbmspb.sql

 

Posted in PL/SQL | Leave a Comment »

Tags: , ,
  |