ora-4062: 'TIMESTAMP / SIGNATURE of NAME has been changed'.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

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

  1. #1
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    70
    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

  3. #3
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Hi ShanDJ,

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

    Thanks,
    Nir

  4. #4
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    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
  •  



Click Here to Expand Forum to Full Width