ora-4062: 'TIMESTAMP / SIGNATURE of NAME has been changed'.

Hi guys,

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 8.1.7.4 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.

Any suggestions?

Regards,
Nir

Hi,
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...

Thanks,

Hi ShanDJ,

We've already recompiled all the related objects , but we still get this error.

Thanks,
Nir

Hi,

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.

Thanks anyway,

Nir