Re: How to retrieve program code ?

Hi Stephan,

try

select text from all_source
where name = '...'
and type = 'PROCEDURE'
order by line;

So long

Tilo

Stephan Gloor wrote:
>
> Hello.
>
> Where is are stored procedure stored in the database ? How can the
> program code be retrieved by exectuing an SQL statement ? All I'm
> currently able to retrieve is the procedure definition, but not the
> source.
> Regards,
> Stephan
Received on Fri Jul 10 1998 - 02:18:30 CDT