Re: Debugging Stored Procedures ...

From: lai <lyekheng_at_hotmail.com>
Date: Thu, 9 Dec 1999 10:17:30 +0800
Message-ID: <384f10b3.0@news.cyberway.com.sg>

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 Wed Dec 08 1999 - 20:17:30 CST