Re: stored procedure

Hi,
Based on the owner of the object try this.

select Text

        from USER_SOURCE
where Name = 'procedure_name'
and Type = 'PROCEDURE'
order by Line;

Or try from DBA_SOURCE, ALL_SOURCE

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