Re: get body of stored procedures and functions?

Mark Harrison wrote:
> How can I get the body of stored procedures and functions?
> I would like to extract some documentation embedded in
> the comments.
>
> Many TIA!
> Mark

SELECT dbms_metadata.get_ddl('PROCEDURE', '<proc_name'>); http://www.psoug.org/reference/dbms_metadata.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org