Valerie,
The text for the procedures are stored in the dba_source tables. Set your environment
to a longer line and select the text where name = procedure.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 04/03/01 04:35PM >>>
What is the SQL command, v$ table or SQL*Plus command to see the contents of
a stored procedure?
I looked at DBA_SOURCE but it stored the code in separate rows based on the
owner and procedure name. Is there any way to see the source code for OEM
view of the procedures? It displays what I want to see but developer doesn't
have access to OEM.
Thanks in advance.
Val
Valerie H. Webber
Management Systems Designers, Inc
Database Administrator
[EMAIL PROTECTED]
704-566-5321
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
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).
