Re: Procedure/functions in Packages, Need more information

From: Thomas Olszewicki <ThomasO_at_noSpm.cpas.com>
Date: Thu, 15 Nov 2001 03:26:39 GMT
Message-ID: <PBGI7.169653$5h5.69575440_at_news3.rdc2.on.home.com>


Salto
Look at the view: ALL_ARGUMENTS..
HTH
Thomas

"Salto" <Salto_at_uswest.net> wrote in message news:3BF19C05.D565D191_at_uswest.net...
> I would like to thank everyone for their input.
>
> I am working with ODBC an have to use SQL statements, cannot
> use describe.
>
> What SQL statement would I use to determine what functions
> and
> procedures exist for packages in all_objects and if they are
> functions
> or procedures.
>
> all_variables tells me what variables exist for a function
> or procedure
> but I do not know if I have a function or procedure.
>
> Can procedures or functions exist without variables and thus
> not appear
> in all_variables ?
>
> Its cross posted ! I do not check every group myself.
>
> Thank You
>
> Salto
>
>
>
>
>
>
>
>
Received on Thu Nov 15 2001 - 04:26:39 CET

Original text of this message