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
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
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
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!
user_source? all_source? dba_source?David A. BarbourOracle DBA, OCPAISD512-414-1002Abdul 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
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 =