Re: How do I check for source code of my procedures ?

From: K POON <kspoon_at_netvigator.com>
Date: Tue, 15 Sep 1998 20:40:54 +0800
Message-ID: <35FE6056.D5683D09@netvigator.com>

try

column text format a132
select text
from user_source
where name = 'YOUR_PROCEDURE_NAME'
and type = 'PROCEDURE'
order by line;

Regards,
K POON hpcheong_at_ncs.com.sg wrote:

> hi,
>
> does anyone know how can i check for source code of my procedures at sqlplus?
> is it possible in the first place? if not, what can be the alternatives?
>
> i am using oracle 7.2.
>
> thanks in advance!
>
> rgds,
>
> evelyn.
>
> -----== 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 Sep 15 1998 - 07:40:54 CDT