Also, I think I've already used TOAD to recompile every bit of PL/SQL.
Ed.
Robbert van der Hoorn wrote:
> "Ed_Zep" <ed_zep_at_ntlworld.com> wrote in message
> news:1153518085.107588.142410_at_i3g2000cwc.googlegroups.com...
> > We're running Oracle 9.2.0.6 database and Developer 9.0.4.2 on RH Linux
> > 3.0.
> >
> > All the forms compile but when I run the first one I get an ORA-04062
> > error.
> >
> > Can this be due to a corrupt library file?
> >
> > I tried the workaround suggested by Oracle but I was wondering can
> > anyone tell me how I can find the package it's failing on?
> >
> > Many thanks, Ed.
> >
>
> Ed,
> ORA-04062 can be caused by several issues, and you don't state which
> workaround you tried.
> It's usually something changed in the database causing your forms (pll's) to
> be recompiled. It's a classic...
>
> Perform actions in this order:
> 1) Compile your database packages
> 2) Compile your plls
> 3) Compile your forms.
>
> Robbert
Received on Fri Jul 21 2006 - 18:47:44 CDT
