-
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,
________________
ShanDJ
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|