Home » Developer & Programmer » Forms » ORA-04062 (Forms 6i, Oracle 10g)
ORA-04062 [message #654223] Thu, 28 July 2016 07:18 Go to next message
chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India
Senior Member
Dears,

Anyways to find exactly which object is creating the ORA-04062 error.

Inspite of setting up the remote_dependencies_mode = SIGNATURE, still am facing this error frequently. Need to identify which object is causing this error, so can be verified and validated.

Thanks

Report message to a moderator

Re: ORA-04062 [message #654225 is a reply to message #654223] Thu, 28 July 2016 08:05 Go to previous messageGo to next message
cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester
Senior Member
The error message should tell you

Report message to a moderator

Re: ORA-04062 [message #654226 is a reply to message #654223] Thu, 28 July 2016 08:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
04062, 00000, "%s of %s has been changed"
// *Cause: Attempt to execute a stored procedure to serve
// an RPC stub which specifies a timestamp or signature that is
// different from the current timestamp/signature of the procedure.
// *Action: Recompile the caller in order to pick up the new timestamp.


query ALL_DEPENDENCIES?

Report message to a moderator

Re: ORA-04062 [message #654229 is a reply to message #654226] Thu, 28 July 2016 08:20 Go to previous messageGo to next message
chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India
Senior Member
Thank you. Let me try to find the DBMS_ERROR_TEXT / ERROR_TEXT to see if it shows the object name, which causes this error.

Report message to a moderator

Re: ORA-04062 [message #654242 is a reply to message #654229] Thu, 28 July 2016 13:09 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe, just maybe you could see some more information if - upon the error - you go to the Help menu and select "Display error". However, I'm afraid that Forms will just inform you that there were no errors recently ...

Report message to a moderator

Previous Topic: Oracle Forms image icons for Buttons
Next Topic: Database Procedure vs Oracle Program Units Procedure vs Library Procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 11 22:47:16 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.