Re: how can I list procedure source

From: gdas <gdas1NOgdSPAM_at_yahoo.com.invalid>
Date: 2000/07/19
Message-ID: <10e8631c.c5ab0827@usw-ex0102-015.remarq.com>#1/1

"John Dunn" <JLDunn_at_ukgateway.net> wrote:
>how can i get the source of a pl/sql procedure or function,
from sqlplus?
>
>John
>

John,
There's a dictionary view called ALL_SOURCE. I don't have the columns on the top of my head (do a desc on it). Sending a select against this view will give you the line #s and source code...

Gavin

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 19 2000 - 00:00:00 CDT