Stored Procedure source?

[ricky]

What command do I use to view the source of a stored procedure?

Thanks.

[Imanuel Greenfeld]

You can use:

select text from USER_SOURCE where name = upper('your proc');

Cheers,

Imanuel.



"ricky" <rforde48@hotmail.com> wrote:
>
>What command do I use to view the source of a stored procedure?
>
>Thanks.

[Reddy]

"ricky" <rforde48@hotmail.com> wrote:

You can query the following table user_source

Eg:

desc user_source

select * from user_source where Condition<>

Regards
Reddy

>
>What command do I use to view the source of a stored procedure?
>
>Thanks.