ORA-04062: timestamp of procedure "" has been changed
Error: ORA-4062
Text: timestamp/signature of %s has been changed
-------------------------------------------------------------------------------
Cause: Attempt to execute a stored procedure to serve
an RPC stub which specifies a timestamp/signature that is different
from the current timestamp/signature of the procedure.
Action: Recompile the caller in order to pick up the new timestamp/signature.
*** Important: The notes below are for experienced users - SeeNote:22080.1
Note: Simply re-executing the procedure that calls the remote one will cause
it to be re-compiled.
Note also that this error is only returned when calling remote procedures.
The way to avoid it as far as possible is to only ever call remote
*packaged* procedures, whose body may be re-built without affecting the
timestamp (stored in the specification).
参考:how to avoid cascading invalidations
It is also advisable to set <Parameter:REMOTE_DEPENDENCIES_MODE> to
SIGNATURE on releases supporting this.