Re: Where is procedure text???

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 30 Dec 1998 18:51:17 +0100
Message-ID: <368A6815.EC776465@psi.de>

If you like to have more comfort use a tool like Hora 3. Hora 3 shows the source code with syntax highlighting. If the the source code contains compilation errors the window is split into two parts. The lower window displays the oracle error text, the upper highlights the corresponding line of the source code. If you move in the error window to another error the upper window scrolls to the corresponding source code.
See http://www.keeptool.com for a 30 days free trial version of Hora 3.

regards Jan Dieckmann

alt_at_interchange.co.uk wrote:

> 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 Wed Dec 30 1998 - 11:51:17 CST