Re: Oracle stored procedure text

From: Marc Parkinson <marcpark_at_starband.net>
Date: Thu, 31 Oct 2002 03:49:27 GMT
Message-ID: <xL1w9.3703$vY5.1483684958@twister2.starband.net>

use the all_source table.

Select text
from all_source
where name = 'WHATEVER'
and type = 'PROCEDURE'
order by line.

Marc Parkinson
Senior Oracle Engineer

"gamaz" <gamaz_at_eathlink.net> wrote in message news:IE1w9.4700$Ik6.433566_at_newsread1.prod.itd.earthlink.net...
> Hi,
> I was wondering if it is possible to get the text of all the stored
> procedure I have in the Oracle server, kind of sp_helptext of Sql Server.
> Thanks.
>
>
Received on Wed Oct 30 2002 - 21:49:27 CST