Re: doubt in sql

From: d.a. <dan_at_nospam.com>
Date: Wed, 05 Sep 2001 13:37:29 GMT
Message-ID: <tUpl7.78418$N9.192387@news1.rdc1.fl.home.com>

Try

select text from all_source where name = 'PROCEDURE_NAME_HERE';

-Dan

Ramola <j_ramola_at_yahoo.co.uk> wrote in message news:65c40e25.0109050447.6f7259b0_at_posting.google.com...
> PROCEDURE show_temp
> argument_name IN/OUT

  DEfault> ------------------------------------------------


>  p_name           IN       DEFAULT

>  p_num            IN       DEFAULT

>
> i want to show the procedure,but when i give
> sql> @<procedurename>
> it gives the error unable to open
> the procedure <procedurename.sql> and
> when i give like this
> show procedure >procedurename>
> it fives the error
> "unknown SHOW option "procedure"
> "unknown SHOW option "<procedurename">
> please give a solution for this...
> how do i open the procedure..
> thanks in advance
> ramola
Received on Wed Sep 05 2001 - 08:37:29 CDT