Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
>
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
![]() |
![]() |