Re: how to get the contents/text of a stored procedure

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 23 Sep 1998 19:07:08 +0200
Message-ID: <36092ABC.4426FBA8@psi.de>

You will get the text with

SELECT text FROM user_source WHERE name = 'proc_name';

but you will be disapointed. Have a look at http:\\www.keeptool.com and download a free trialversion of Hora 3. Hora 3 is an administration tool for Oracle databases and offers a graphical PL/SQL ide.

regards Jan Dieckmann
jan.dieckmann_at_KeepTool.com

sureshvv_at_hotmail.com wrote:

> Can someone help me with this? using sql*plus?
>
> Is there a FAQ for this group?
>
> thanks.
>
> suresh
>
> -----== 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 Sep 23 1998 - 12:07:08 CDT