Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: How can I find the error in a Procedure programtically

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

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 2 Jul 2003 08:57:21 -0700
Message-ID: <3722db.0307020757.2f4a1adc@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US