OraFAQ Forum: Forms » ORA-04062: signature of package has been changed

Home » Developer & Programmer » Forms » ORA-04062: signature of package has been changed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04062: signature of package has been changed [message #166361]

Wed, 05 April 2006 21:57

juicyapple
Messages: 92
Registered: October 2005

Member

I changed several column datatype size from 80 to 150

alter table MNG
modify remark varchar2(150)
modify teb1 varchar2(150)

but I encounter the error when run the system

ORA-04062: signature of package "SYSM.PKG_MNG" has been changed

Is the error caused by changing on the column size?

Please advise.
Thanks.

Report message to a moderator

Re: ORA-04062: signature of package has been changed [message #166368 is a reply to message #166361]

Thu, 06 April 2006 00:21

aciolac
Messages: 242
Registered: February 2006

Senior Member

Try to recompile the package "SYSM.PKG_MNG". The description of error is:
}/software/oracle> oerr ora 4062
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.

Report message to a moderator