>-----Original Message-----
>From: Webber Valerie H [mailto:[EMAIL PROTECTED]]
>
>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.
You can use dba_source
select text
from dba_source
where owner = 'PROCEDURE_OWNER'
and name = 'PROCEDURE_NAME'
order by type, line ;
