ora-4062: 'TIMESTAMP / SIGNATURE of NAME has been changed'.
One of ours developer gets frequently the error message:
ora-4062: 'TIMESTAMP / SIGNATURE of NAME has been changed',when he compiles a form against the dev db. (Oracle 126.96.36.199 on Sun Solaris).
The strange thing is that this error is not appeared against another db which is a copy of the dev db.
Oracle has consulted us to set the parameter : remote_dependencies_mode=SIGNATURE.
We've set this paramere in all the databases that related to the application. All the databases are the same regaring its init*.ora.
The problem appeares in inly one of the databases.
Did the form is using any Stored procedures? If it is using, recompile the stored procedure, so that the timestamp of it will be changed to current timestamp.
Hope this will help you...
We've already recompiled all the related objects , but we still get this error.
We've probably succeded solving the problem by changing IN parameters of the form related procedures , from %type of changed table columns to a real data type.
Click Here to Expand Forum to Full Width