Re: Debugging Stored Procedures ...

Dinesh wrote in message <828tve$gp8$1_at_newsie.singa.pore.net>...
>Hi.....
>
>How can I view a stored procedure or function that has been created in
>Oracle via CREATE PROCEDURE or
>FUNCTION.
all_sources

>
>Where a VIEW has been created, how can I determine what the source of the
>CREATE VIEW statement
>is ? For example, I have a VIEW created by some
>extinct vendor but I need to know the source of the
>statement that created the VIEW ?
>

all_views

>Also, if there are compilation errors, how can that be viewed? At the
>moment, all it says is that there are
>compilation errors but I haven't the foggiest idea of where
>the error occured.

show errors

>
>Assistance is greatly appreciated.
>
>Regards.
>
>
Received on Thu Dec 09 1999 - 00:00:00 CET