ORA-04068

[DMahesh]

How to avoid this error:
ORA-04068: existing state of packages has been discarded


It goes away second time when I execute the package. But I want avoid altogher. Any help appreaciated. Thanks.

 

[carp]

You can start a new session and it will go away.
The problem is that if the object has been recompiled since the last time your current session used it, you will get this error. That's just the way Oracle works.

 

[lewisp]

Ask your DBA to change the REMOTE DEPENDENCIES from TIMESTAMP to SIGNATURE.

 

[DMahesh]

Changing REMOTE DEPENDENCIES from TIMESTAMP to SIGNATURE did not work.

 

[lewisp]

What are you doing to the procedure each time? Are you changing code within it or are you altering the number of parameters in the call?

 

[DMahesh]

How/When I get this error?
I have two sqlplus sessions open.
Session1: I execute the pkg.procA();
Seesion2: I make some logic modification in pkg body (but no changes to paramters or specification)

and then when I go back to Session1 and execute pkg.procA
I get the error. But when I execute the pkg again I don't get the error.

Let me know if you need further details..

Thanks