Re: Procedure/functions in Packages, Need more information

From: Matt B. <gtimatt_at_home.com>
Date: Wed, 14 Nov 2001 05:14:10 GMT
Message-ID: <C4nI7.12316$Sx.4134058@news1.elcjn1.sdca.home.com>

"Salto" <Salto_at_uswest.net> wrote in message news:3BF19C05.D565D191_at_uswest.net...
> 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.

SELECT OBJECT_NAME, OBJECT_TYPE
FROM DBA_OBJECTS
WHERE OBJECT_NAME = 'FOO' (replace FOO with your stored program unit name of course...and it assumes you have permissions to see dba_objects)

-Matt Received on Tue Nov 13 2001 - 23:14:10 CST