Dba_Dependecies ?

From: Andre Norman <andre.norman_at_sympatico.ca>
Date: Sat, 8 Feb 2003 19:20:56 -0500
Message-ID: <kbh1a.7039$Zt4.1265703_at_news20.bellglobal.com>

Hi,
I have a proc that lists several views, which depend on other views before finally reaching a table.
ie
proc

    view1 view2

               view3
                    view4
                        table1

Quering the data dictionary :
select name, reference_name, reference_type from dba_dependencies
where name = 'proc_name';
only returns view1, the view thats referenced by the proc. Is there a way that I could get all child dependencies between the proc and the tables.
Thanks in advance for your help.
Regards, Received on Sun Feb 09 2003 - 01:20:56 CET