Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL Command to view stored procedure

Re: SQL Command to view stored procedure

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 03 Apr 2001 13:08:35 -0700
Message-ID: <F001.002E058D.20010403130707@fatcity.com>

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).
Received on Tue Apr 03 2001 - 15:08:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US