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

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

SQL Command to view stored procedure

From: Webber Valerie H <Valerie.H.Webber_at_irs.gov>
Date: Tue, 03 Apr 2001 12:36:49 -0700
Message-ID: <F001.002E0439.20010403123546@fatcity.com> 









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 
Received on Tue Apr 03 2001 - 14:36:49 CDT












Original text of this message













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