Xref: alice comp.databases.oracle.misc:17262
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: karmit@my-dejanews.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to retrieve program code ?
Date: Wed, 08 Jul 1998 04:49:42 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 28
Message-ID: <6nutp6$j34$1@nnrp1.dejanews.com>
References: <35A1E435.70F8A7E9@access.ch>
X-Article-Creation-Date: Wed Jul 08 04:49:42 1998 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)

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@access.ch>,
  stgloor@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