Re: How to retrieve program code ?

Try this:

select text from user_source
where name = 'MYPROC'
and type = 'PROCEDURE'
order by line

user/all/dba_source has all procedure,function,package and package body source as well as type and type body definitions.

K.

In article <35A1E435.70F8A7E9_at_access.ch>,   stgloor_at_access.ch 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 07 1998 - 23:49:42 CDT