Can't view a package spec&body in V8

[SeanYeung]

In Oracle 10g, i create a package test with user HR.
Then i create a new user 'query' with privilge 'select any table','select any dictionary'. And enable the preference 'Use DBA View '.
But i can't view the package hr.test by user 'query' . It's avaible in V7.15.
Thanks.

 

[Marco Kalter]

Perhaps you have not set the User Selector of the Object Browser? By default it is set to . Set it to the correct user or to to see the packages owned by user HR.

 

[SeanYeung]

I can find the package in Object browser and then open it ,but in sql windows ,right click package name ,the pop menu didn't show 'View the package spec&body'.In my database there is many a lot of packages in a schema ,so it will take a long time to open the folder 'package' in object browser .

 

[Mindaugas]

SELECT tpz_utl.format('%s %s', x1, x2) FROM dual;

This works for me with right click in SQL window. Do you have access rights?

 

[SeanYeung]

yes, i have access right .
In object browser i can open it,but not in sql window.
And in V7 ,it works well both in browser and sql window.

 

[Marco Kalter]

Does the package name in the SQL Window include the owner prefix?

 

[SeanYeung]

yes ,i already add the schema name as prefix ,just like

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[SeanYeung]

i have sent debug file to you.