ORA-04068 : always returns

Please help because this is running in production-environnement and give the users a lot of problems.
Please help because this is running in production-environnement and give the users a lot of problems.
Please help because this is running in production-environnement and give the users a lot of problems.

Hi,

from a form in database X I'm calling a procedure from another database Y (both Oracle7)

Since yesterday, in that form I get ORA-04068 : existing state of packeges has been discarded.

Everything worked fine for more than 2 years.

I recompiled the procedure (and all the other procedures) but nothing changed.

I finaly dropped that procedure and made it again, new grant, new alias but that form still gives me ORA-04068.

Everywhere I look on the internet, the solution is 'try it again and the problem will be solved'.

I tryed the things above.

Has someone another idea?

Please help because this is running in production-environnement and give the users a lot of problems.

Thanks

Dirk Received on Tue Sep 03 2002 - 08:25:44 CEST