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: Dependencies in PLSQL app?

Re: Dependencies in PLSQL app?

From: Peter Schneider <peter.schneider_at_okay.net>
Date: 1998/03/25
Message-ID: <351987f2.7739580@news.okay.net>#1/1

On Fri, 20 Mar 1998 10:09:32 +0100, Ilkka Pynnonen <ilkka.pynnonen_at_ubs.com> wrote:

>Hi
>I'm looking for a tool to produce a report of the dependencies in the
>PLSQL application ie.
>which procedures call a procedure
>which procedures update/read a table etc.
>
>Do you know such a tool?
>
>Thanks for you help
>Ilkka Pynnonen
>

Hi Ilkka,

just have a look at the user_dependencies data dictionary view.

HTH
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net
Received on Wed Mar 25 1998 - 00:00:00 CST

Original text of this message

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