RE: View for Procedure/Function SQL Code
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
andobject_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
[EMAIL PROTECTED]
> -Original Message-
> From: Abdul Aleem [SMTP:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: View for Procedure/Function SQL Code
user_source? all_source? dba_source? David A. BarbourOracle DBA, OCPAISD512-414-1002 Abdul Aleem <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]02/13/2002 11:13 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: View for Procedure/Function SQL Code Hi!Is there a view to see the code written in the procedure/function code, theparameters, return types etc.TIA!Aleem--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Abdul Aleem INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: View for Procedure/Function SQL Code
Hi The text field of the DBA_SOURCE or USER_SOURCE can help u. Ayyappan.S -Original Message- Sent: 14 February 2002 15:13 To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ayyappan S INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: View for Procedure/Function SQL Code
Hi Aleem, You can view this info in DBA_SOURCE view. Best way is to query like this . SET PAGES 100 select text from dba_source where name = 'EUL$GET_FOLDER_NAME' and OWNER = 'TEST" ; why Try selecting all columns and see the diff ;-) HTH, Rajesh -Original Message- Sent: Thursday, February 14, 2002 11:13 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: View for Procedure/Function SQL Code
Hi, DBA_SOURCE can help you Sinardy -Original Message- Sent: 14 February 2002 15:13 To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: View for Procedure/Function SQL Code
Hi, DBA_SOURCE can help you Sinardy Happy CNY & 14 Feb -Original Message- Sent: 14 February 2002 15:13 To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
