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: Query for functions and procedures in Package

Re: Query for functions and procedures in Package

From: Roy Klassen <rklassen_at_pei.sympatico.ca>
Date: 1997/06/19
Message-ID: <01bc7d04$05423ee0$0f1e22cf@fred.sympatico.ca>#1/1

The view is DBA_SOURCE.

You can query the source code of a PL/SQL package. You can see from that what procedures or functions are called.

Stephen Lappin <SL_at_RTEL.co.uk> wrote in article <F04D34338485D011923F00A024DFE6D9094DB9_at_exchpost>...
> Is there dictionary view available that can be queried to show what
> procedures and functions are contained within a Pl/SQL Package?
>
> Slainte mhath
> Stephen Lappin
>
>
>
  Received on Thu Jun 19 1997 - 00:00:00 CDT

Original text of this message

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