Re: Text of a stored procedure

From: Chris Hamilton <toneczar_at_erols.com>
Date: 1998/04/29
Message-ID: <01bd738a$803e75a0$73344b9b@chrish.hq.usace.army.mil>#1/1

Scott Patterson <scott.patterson_at_trilogy.com> wrote..

> I need to extract the text of a stored procedure. Is there an Oracle
> procedure similar to the SQLServer sp_helptext? Or some other means of
> extracting the text?

You can use SQL*Plus ...

select text
from dba_source
where owner = upper('&proc_owner')
and name = upper('&proc_name')
order by line;

Chris

---

christopher.h.hamilton_at_usace.army.mil
U.S. Army Corps of Engineers
http://www.serve.com/cowpb/chamilton.html Received on Wed Apr 29 1998 - 00:00:00 CDT