Re: Where is procedure text???

From: Vandana <vandana_at_pacific.net.sg>
Date: 19 Dec 1998 10:44:47 GMT
Message-ID: <01be2b3a$fb041980$a14618d2@regresea>

Hi there

You can query USER_SOURCES or DBA_SOURCES

SELECT TEXT
FROM USER_SOURCE
WHERE NAME = 'your procedure name'
ORDER BY LINE Regards

N.Prabhakar

Shajith <shajith_thaze_at_bose.com> wrote in article <75ebsh$a0c$1_at_ligarius.ultra.net>...
> Look at sys.dba_source
>
> alt_at_interchange.co.uk writes: > Hi
> >
> > Can someone tell me if there is a table in the data dictionary that
holds the
> > syntax for procedures / packages that have been created by a user (like
the
> > text field in DBA_VIEWS) ? I've looked high and low and can't find it -
and no
> > I don't have Enterprise Manager tool set either...... wish I had
though!
> >
> > Please email response to alt_at_interchange.co.uk
> >
> > Thanks for the help.
> >
> > Al
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

>
>
Received on Sat Dec 19 1998 - 04:44:47 CST