Unable to view package list in schema brower for particular schema only

Toad for Oracle
1

Hi All,

I am Unable to view package list in schema brower for particular schema only.

While login into the schema am getting an below error.

Error :-

ORA-06550: line 40, column 9:
PLS-00302: component ‘DBMS_APPLICATION_INFO’ must be declared
ORA-06550: line 40, column 5:
PL/SQL: Statement ignored

Regards

Balaji.R

2

Toad expects that you have the EXECUTE privilege on package SYS.DBMS_APPLICATION_INFO. It is granted to PUBLIC by default. Your DBA must have revoked that. Try talking to him/her and see if you can get that privilege.

3

Hi ,

After getting grant for package SYS.DBMS_APPLICATION_INFO also am facing same issue.

Regrds

Balaji.R

4

Balajiram,

You should restart Toad after receiving that grant. Toad only checks for it once. If that doesn’t help you, please do these steps so we can diagnose your problem.

  1. Start Toad but don’t connect to any database yet.

  2. On the main menu, click Database -> Spool SQL -> Spool to Screen

  3. Connect to the database and try to open SChema Browser -> Packages

  4. At the output window on the bottom, Toad will have collected all of the SQL that it ran along with any errors. Copy and paste that here.

Thanks

John