Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about finding package dependencies

Re: Question about finding package dependencies

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 30 Jan 2003 11:56:22 +0100
Message-ID: <b1b0fa$1157vk$1@ID-152732.news.dfncis.de>


Hi, Ryan.

Sorry but afaik there is no other way than to write an extra sp to do this ... mine is still under construction.
It is basically selecting from dba_source, cutting it all into word pieces (because there maybe incredibly bad formatted code lines...) and writing the stuff into a table. The analysis what functions do what then starts from there ...

Maybe this is reinventing the wheel ... but I did not find a better way.

(hth)

Jan

"Ryan" <rgaffuri_at_cox.net> schrieb im Newsbeitrag news:K9%Z9.54656$GX4.2307101_at_news2.east.cox.net...
> I know I can use USER_DEPENDENCIES and I can find out dependencies at the
> package level. How do I find out what functions and procedures inside
those
> packages are calling?
>
>
Received on Thu Jan 30 2003 - 04:56:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US