Re: How do I see the source code of a stored procedure through Sql*plus ?

In sql plus
The table which stores the details of the stored procedures is ALL_SOURCE. This should be your query.

Select TEXT
from ALL_SOURCE
where NAME = (your store procedure name).

This should give you the source code.

have fun....

In article <7cmf2a$qdi$1_at_nnrp1.dejanews.com>,   sreeramav_at_my-dejanews.com wrote:
> How do I see the source code of a stored procedure through Sql*plus ?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 15:56:28 CST