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_at_news1.elcjn1.sdca.home.com>
Date: Wed, 14 Nov 2001 05:14:10 GMT
Message-ID: <C4nI7.12316$Sx.4134058_at_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 Wed Nov 14 2001 - 06:14:10 CET