Re: ORA-04062: name of name has been changed

The very first thing to do is change the remote_dependencies_mode to signature.

You'll also get the error if your db procedure has more than 55 parameters.

Also, Oracle7 has more situations when the 4062 error occurs, so going to 8i will ease some of the problems.

John Alexander
www.SummitSoftwareDesign.com

Lefteris Vakalis <evakalis_at_singular.gr> wrote in message news:968849326.418625_at_athnrd02.forthnet.gr...
> Does anybody knows the actual reason of this error message, obtained by a
> form builder application when trying to run it on the client's database?
> The action suggested by "Oracle Errors" document is to:
> "Recompile the caller to obtain the new timestamp."
> Yes, but where? If I recompile the form to my development database and
 send
> it to the client I'll get the same error. Compiling the form on the client
> is out of question. So it must be another way to get out of this
 problem...
> There are two calls to database store functions, which are the same in
> client's database and in my development database except from a blank line
> added in the middle of the code to my development database. Geting the
> client's version here and recompiling the form does not resolve the
 problem.
> Maybe changing the REMOTE_DEPENDENCIES_MODE initialization parameter to
 use
> the "signature checking" instead of "timestamp checking" is better?
>
> Any suggestion will be welcomed.
> Thanks in advance
>
> Lefteris Vakalis
>
>
>
Received on Wed Sep 13 2000 - 21:29:35 CDT