Recent content by SeanYeung

i have sent debug file to you.

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

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.

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 .

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.