Re: ORA-04062

From: Nick Folkes <nick.folkes_at_hyperlink.com>
Date: Thu, 10 Feb 2000 18:19:30 -0000
Message-ID: <87uvg1$dth$1@quince.news.easynet.net>

Wilhelm,

This is a known problem with Forms5.

It's caused by the package changing timestamp. To work around the problem

Step 1) - Set the init.ora parameter remote_dependencies_mode = SIGNATURE
Step 2) - Restart the database
Step 3) - Recompile the database package
Step 4) - Recompile the form

This should resolve you problem

Regards

Nick.

Wilhelm Thieme <w.thieme_at_consunet.nl> wrote in message news:87uv4j$i78$1_at_nereid.worldonline.nl...
> hi everyone
>
> I'm using Forms 5/Oracle 8.04 on NT
>
> Sometimes when a stored procedure is called from a form this error occurs:
>
> ORA-04062 name of name has been changed
> An attempt was made to execute a stored procedure to service a remote
> procedure call stub that specifies a timestamp or signature that is
> different from the current timestamp or signature of the procedure.
> Recompile the caller to obtain the new timestamp.
>
> I'm not using any distributed remote procedure calls at all!
>
> Recompiling the form and/or the stored procedure does'nt help.
>
> Any idea's ??
>
> Thanks
>
> Wilhelm
>
>
>
Received on Thu Feb 10 2000 - 12:19:30 CST