Re: How to retrieve program code ?

From: <the_very_at_my-dejanews.com>
Date: Wed, 08 Jul 1998 12:11:14 GMT
Message-ID: <6nvnl1$k62$1@nnrp1.dejanews.com>

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
>
>

Hi,

look in the view dba_source as
SELECT
RTRIM(TEXT) TEXT
FROM dba_source
where name = upper(..fill in source name here ..) ORDER BY type,line;

you can specify type (PROCEDURE,FUNCTION etc). that can speed things up.

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