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

From: <mashy_at_null.net>
Date: Tue, 15 Sep 1998 16:22:17 GMT
Message-ID: <6tm47o$8o8$1@nnrp1.dejanews.com>

Hiya !

U can use the user_source table to get the necessary code from the database for eg :

set lines 100
col text form a80

Select text
From user_source
Where name like 'YOUR PROCEDURE NAME' and type like 'PROCEDURE'
order by line
/

This will list out the stored procedure from the database .

Hope it solves the mystery for you !

Mashya ...

In article <6tl25h$2m0$1_at_nnrp1.dejanews.com>, 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
>

-----== 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 - 11:22:17 CDT