Title: SQL Command to view stored procedure

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


Reply via email to