Re: Forms 9.0.4.2

Sorry Robert, I'm using Google's front end to newsgroups. I didn't know it caused a problem.

I'll give your suggestion a go and see if it works.

Thanks, Ed.

Robbert van der Hoorn wrote:
> 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 - 11:16:33 CDT