Re: stored procedure

From: Greg Parsons <parsons_at_intermetrics.com>
Date: 1997/11/10
Message-ID: <346710D1.558D26C2@intermetrics.com>#1/1

Hi,

Try within SQLPlus:
set head off
spool splfil.lst
select text from dba_source where name = 'PROCNAME' order by name, line; spool off
set head on

You will need to login as a DBA user and this assumes the procedure name is unique throughout the database. If not, include " and owner = 'OWNERNAME'" in the where clause. If you cannot login as a DBA user, you can probably run the same script replacing dba_source with user_source.

Greg Parsons

Ong Chin Hui wrote:
>
> Can someone enlighten me on how to extract the script of a stored
> procedure in Oracle 7.3 ?
Received on Mon Nov 10 1997 - 00:00:00 CST