Re: Procedures and Functions in Package/Package body

I am working with ODBC an have to use SQL statements.

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 ?

Salto

Marc wrote:

> desc packagename. that gives you the functions/procedures that can be
> addressed
>
> "Salto" <Salto_at_uswest.net> wrote in message
> news:3BF12BEC.4BA52763_at_uswest.net...
> > Help
> >
> > Using sqlplus, How do I determine the procedures and
> > functions in a package / package body.
> >
> > I have looked at all_sources and all_objects but cannot see
> > how to connect the information together.
> >
> > If you know what tables to use and or SQL please let me
> > know.
> >
> > Thank You
> >
> > Salto_at_uswest.net
> >
> >
> >
Received on Tue Nov 13 2001 - 16:12:25 CST