Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there a way to check which procedure, stored procedure is not compiled.
Hello,
I know that my package are ok and compile correctly.
Thanks X this is exactly what i want.
Rangdalf
"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<418a763d$0$3449$626a14ce_at_news.free.fr>...
> "rangdalf" <rangdalf_at_hotmail.com> a écrit dans le message de
> news:fd099c36.0411040131.788c1f85_at_posting.google.com...
> > Hello,
> >
> > I would like to know if it is possible to write a script or function
> > which check all procedures, functions, stored procedures and display
> > which one are not compiled.
> >
> > thanks in advance for your help.
> >
> > Rangdalf
>
> There is no need to know that as Oracle dynamically recompiles invalid objects.
> It's more important to know which ones contain errors with:
> select distinct owner, name, type from dba_errors;
Received on Fri Nov 05 2004 - 02:02:00 CST