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: Invalid packages with ORACLE 8i

Re: Invalid packages with ORACLE 8i

From: Francois PUECH <fpuech_at_ekip.fr>
Date: Wed, 14 Mar 2001 11:54:40 +0100
Message-ID: <95mn89.glv.ln@charon.ie>

Hi Eric,

Maybe my question wasn't clear enough...

NO operation is made on these procedures (except of course using them...). That's why the problem is strange. The last time I have got this kinda problem was because of memory problem.

François

Carlo Pereti hotmail.com> <carlo_pereti@<nospam> a écrit dans le message : %Kur6.167$1b3.767204_at_nnrp1.proxad.net...
> Look in "Oracle Administrator guide", "General Management of Schema
 Objects"
> "Managing Object dependencies", "operation that affect object status"
>
> Eric
>
> "Francois PUECH" <fpuech_at_ekip.fr> wrote in message
> news:s6pl89.7vo.ln_at_charon.ie...
> > Since we migrated to ORACLE 8.1.6 we have strange problems with the
 stored
> > procedure.
> >
> > Periodically some stored procedures turn invalid. We just then have to
> > recompile then and it is ok but this is a problem for production.
> >
> > Does anyone know something about it ?
> >
> > Thanks.
> >
> > François
> >
> >
> >
>
>
Received on Wed Mar 14 2001 - 04:54:40 CST

Original text of this message

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