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 Wed Nov 14 2001 - 21:26:39 CST
