Get package dependencies

[oneworld95]

Hi. Is there a way in PL/SQL Developer 7 to get all the objects that a particular Oracle 9i package is depended on? For example, I'd like to get all the tables, views, functions, and procedures my package requires so when requesting a copy to our production database, the DBA can quickly get it done without running into errors about objects missing on production. Thanks.

 

[Marco Kalter]

You can get this information from the References folder under the package specification and package body in the Object Browser.

You can also run a query on the sys.all_dependencies or sys.dba_dependencies view.

 

[oneworld95]

Thank you, Marco. I hadn't even noticed that! That's exactly what I needed.