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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: