Re: Stored Procedures

From: Eric & Carole Kamradt <kamradt_at_inconnect.com>
Date: 1997/08/05
Message-ID: <33E77B92.6642CFD2@inconnect.com>#1/1

try -
Do the select of the internal tables (user_source) from SQL*Plus or SVRMGRL and
spool the output to a file. Then you can edit that output file.

Steven H. wrote:

> Is there an easy way of retrieving stored procedures from
> a database (Oracle 7.1)? At the moment we have to do a
> select statement in SQL Plus to retrieve the code from one
> of the internal tables, but the output is not easy to manage -
> we have to select the output with the mouse and copy it into
> another program.
>
> Thanks in advance.
>
> Steven H.

--
eric kamradt
hm: (801) 567-0912
mailto: kamradt_at_inconnect.com
http://www.inconnect.com/~kamradt/resume.html

Received on Tue Aug 05 1997 - 00:00:00 CDT