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

I looked at bit around to find what you're looking for, and it seems to me that this info isn't stored by Oracle. At least not in the dynamic views (the V$ and its underlying tables such as sys.error$, sys.obj$, ...). The only place left to check for this info is the fixed tables (get the list from v$fixed_tables to see the list if you're interested). You can see the procedure's dependencies in USER(DBA)_DEPENDENCIES, which might be useful to you. This is what Oracle uses internally (or I sould say sys.dependency$) to decide which objects to invalidate when an underlying object is altered. Hope that helps a bit.

Daniel

> 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.
Received on Wed Jul 02 2003 - 10:57:21 CDT