Re: SQL Command to view stored procedure

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

>>> Valerie.H.Webber_at_irs.gov 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
Valerie.H.Webber_at_irs.gov
704-566-5321

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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).