How to view a Stored procedure 2

[iolaper]

I'm using Oracle9i and I have created some stored procedures in them.
Can any of u tell me how to view the stored procedure?
Thanks in advance..

 

[LKBrwnDBA]

Tyr this:

SELECT TEXT FROM USER_SOURCE WHERE NAME='MY_PROCEDURE';

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[iolaper]

Thanks.. works!

 

[sem]

To be more precise:

SELECT TEXT FROM USER_SOURCE WHERE NAME='MY_PROCEDURE' AND TYPE='PROCEDURE' order by LINE;
[code]

Regards, Dima
[URL unfurl="true"]http://seminihin.narod.ru[/URL]