RE: View for Procedure/Function SQL Code

From: אדר יחיאל <adary_at_mehish.co.il>
Date: Thu, 14 Feb 2002 08:44:59 -0800
Message-ID: <F001.0040FCCD.20020214080831@fatcity.com>

Hello Aleem

I did a trace from toad and here are the results:

14/02/2002 6:06:10 PM

select /*+ CHOOSE */
 CREATED, LAST_DDL_TIME,
 OBJECT_ID, STATUS, TIMESTAMP
from ALL_OBJECTS
 where object_name = :objname
 and object_type = :objtype
 and owner = :ownere

:OBJNAME = PSTUB
:OBJTYPE = PROCEDURE
:OWNERE = SYS

14/02/2002 6:06:11 PM

select /*+ CHOOSE */ TEXT from ALL_SOURCE where OWNER= :lOWNER and NAME=:NAME and type = :BTYPE order by LINE

:BTYPE = PROCEDURE
:LOWNER = SYS
:NAME = PSTUB

14/02/2002 6:06:11 PM

select PRIVILEGE, GRANTEE, GRANTABLE, GRANTOR  from all_tab_privs
 where table_name = :tname
 and table_schema=:lowner
 order by grantee

:LOWNER = SYS
:TNAME = PSTUB
14/02/2002 6:06:14 PM

Select /*+ CHOOSE */ Line, Position, substr(text,1,200) text From All_Errors where owner=:owner and name=:ObjName and type=:objType order by sequence

:OWNER = SYS
:OBJNAME = PSTUB
:OBJTYPE = PROCEDURE

14/02/2002 6:06:15 PM

Select /*+ CHOOSE */ distinct
  owner uses_owner,
  name object_used,
  type
from ALL_DEPENDENCIES
where
 referenced_owner=:owner and
 referenced_name=:name and
 ( referenced_type<>'NON-EXISTENT') and  ( referenced_type=:type
 )

:NAME = PSTUB
:TYPE = PROCEDURE
:OWNER = SYS

14/02/2002 6:06:17 PM

Select /*+ CHOOSE */ distinct

  referenced_owner uses_owner,
  referenced_name object_used, 
  referenced_type 

from ALL_DEPENDENCIES
where
 owner=:owner and
 name=:name and
 ( type=:type
 )

:NAME = PSTUB
:TYPE = PROCEDURE
:OWNER = SYS

14/02/2002 6:06:19 PM

select /*+ CHOOSE */ argument_name Argument, data_type, in_out, data_length, data_precision, default_value  from all_arguments where (owner=:lowner) and  (data_level=0) and
 (object_name=:objName)
 and (package_name is null)
and object_id = (
 select object_id from
 all_objects where (owner=:lowner) and
 object_name =:objName
 and object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION'))  order by position

:LOWNER = SYS
:OBJNAME = PSTUB
14/02/2002 6:06:34 PM

select /*+ CHOOSE */ TEXT from ALL_SOURCE where OWNER= :lOWNER and NAME=:NAME and type = :BTYPE order by LINE

:BTYPE = PROCEDURE
:LOWNER = SYS
:NAME = ODCISTATSOPTIONSDUMP

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Abdul Aleem [SMTP:abchaudhary-ho_at_beaconhouse.edu.pk]
> Sent: Thu, February 14, 2002 9:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: View for Procedure/Function SQL Code
>
> Hi!
> Is there a view to see the code written in the procedure/function code,
> the
> parameters, return types etc.
> TIA!
>
> Aleem
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Abdul Aleem
> INET: abchaudhary-ho_at_beaconhouse.edu.pk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Feb 14 2002 - 10:44:59 CST