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_Zep" <ed_zep (AT) ntlworld (DOT) com> wrote

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

Hi Robbert,

thanks for the response.
The workaround I tried was changing the init.ora thus:
'remote_dependencies_mode = signature' and recompiled the form.

How can I tell which packages/procedures the form is calling, please?

Cheers, Ed.

Also, I think I've already used TOAD to recompile every bit of PL/SQL.

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 (DOT) com> wrote

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

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:

On 22 Jul 2006 09:16:33 -0700, "Ed_Zep" <ed_zep (AT) ntlworld (DOT) com> wrote:


Please stop top-posting.

You only need to hit ctrl-end to stop top-posting.
You aren't handicapped, are you?

--
Sybrand Bakker, Senior Oracle DBA

You really are pathetic, aren't you?
What if I *was* handicapped? Do you have something against people who
are?

On 22 Jul 2006 15:40:47 -0700, "Ed_Zep" <ed_zep (AT) ntlworld (DOT) com> wrote:

around: it is you.

--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
I wonder why you're like this and I know you're not just like this in
Oracle groups because I saw a message in a classical musical newsgroup
where you claimed Bach and the piano don't go together!

Sounds like too much hard work (mind you, like you say, I am lazy).

Thank you for the suggestion of the on logon trigger, though.