Re: Peeking in on Stored Procedures

From: Nevin Hahn <nevin.hahn_at_born.com>
Date: Fri, 01 Sep 2000 06:06:32 GMT
Message-ID: <39AF4753.6591353F@born.com>

Hi Joe,

select text from user_source where name = 'PROCEDURE_NAME';

or all_source, dba_source as applicable, should do the trick

Nevin Hahn
nhahn_at_evoke.com

jgotthelf_at_my-deja.com wrote:

> Hi,
>
> How does one see the code of a stored procedure from SQL+. I know how
> to do this from Enterprise Manager, but quite frankly, that beast is a
> bit unwieldy, and teaches me nothing - in addition to screwing things
> up on occasion!
>
> Joe G.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 01 2000 - 01:06:32 CDT