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 - See
Note: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.

    参考:REMOTE_DEPENDENCIES_MODE

posted @ 2012-04-19 16:19  大卫.宋  阅读(2780)  评论(0编辑  收藏  举报