Re: PACKAGES DEPENDANCE

anonymkim wrote:
> Hello,
> I have written some PLSQL packages in ORACLE. I want to know if a PLSQL
> program which gives all the packages used in a package exist.
>
> Thanks.
>
> AK

SELECT name
FROM dba_dependencies
WHERE referenced_name = '<object_name>'
UNION
SELECT referenced_name
FROM dba_dependencies
WHERE name = '<object_name>';

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)