Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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