Oracle Database Discussions

Hi,

Environment:
We host our java 1.5 , j2ee application on multi-clustered environment connecting 2 app servers to 1 node of oracle RAC cluster.
We have batch jobs running daily in the morning, that does a new data upload to the production DB. (Load to a Tmp table, Drop the production table, rename Tmp table to production table and re-create indexes.)

Recent Change:
We recently migrated from Oracle 10.0 version to 10.1...

Issue:
With the recent change, we started facing the error, 'ORA-04062: timestamp of function has been changed' for the STORED PROCEDURES that we use in the application. And I am sure that this is because of the job that runs in the morning, as it re-creates the tables that are used by the stored-procedures. So the stored-procedures become invalid and requires recompile. And we did recompile as well, but still the same error. And then changed the mode from 'TIMESTAMP' to 'SIGNATURE', but still the same error(ORA-04062: TIMESTAMP (and not SIGNATURE) of function has been changed)...

We are stuck here not knowing what to do. It would be helpful if you can assist me here with any idea on why this is happening? The only solution we found right now is to restart the tomcat on application servers. This resolves the issue to 100%. Would this mean there is a problem with my database connection in the application?

Thank you,
Pradeep.