Thanks a lot Marc. I appreciate it.
"Marc Parkinson" <marcpark_at_starband.net> wrote in message
news:xL1w9.3703$vY5.1483684958_at_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 - 22:13:07 CST
