Re: Forms 9.0.4.2

Ed, please put reactions on bottom of post or in line (do not top post). See below...

"Ed_Zep" <ed_zep_at_ntlworld.com> wrote in message news:1153525664.562997.106920_at_m79g2000cwm.googlegroups.com...
> 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
>

1. Just check if all your db-stuff is compiled and valid (e.g. with toad) but beware: if you compile a package with toad, and compile both spec and body, other packages may become invalid.
2. Look in the source code of your forms which pll's are used (attached libraries) and compile them in bottom to top order
3. compile your form.

If you compile against a development database but run againts a production database, you will have to repeat these steps on the production system (so compile your form while connected to production database!)

Robbert Received on Sat Jul 22 2006 - 05:46:13 CDT