Re: How can I find the error in a Procedure programtically

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Wed, 02 Jul 2003 15:34:59 GMT
Message-ID: <DYCMa.290$aD6.11@nwrddc03.gnilink.net>

"charlie cs" <cs3526(no spam)@yahoo.com> wrote in message news:A3yMa.9186$tw3.7756_at_nwrdny02.gnilink.net...
> We have a procdure. Every night it will become invalid, but it will be
> recompiled automatically by our scripts. There is no bad influence on our
> production, so this problem was unattended for a long time.
>
> I am interested in writing a scripts, which will record why the procedure
is
> invalid.
>
> Could some one tell me which dynamic view I should look to get the error
> message if a procedure becomes invalid?
>
> Your help is highly appreciated.
>
>

Try looking in user_errors / all_errors / dba_errors to see if it provides a clue.
... and next time, please post the Oracle version.

Anurag Received on Wed Jul 02 2003 - 10:34:59 CDT