| Signature of package 'xxx' has been changed [message #51909] |
Fri, 21 June 2002 00:57  |
SANTOSH DURGUDE
Messages: 3
Registered: June 2002
|
Junior Member |
|
|
Sir,
When I executes package body in db. after that if I run the form, the above error occured.
Then I have to compile the Forms, in which this error occured. That programs call one back end Function.
After this Form run well..
- SAntosh
|
|
|
|
| Re: Signature of package 'xxx' has been changed [message #51915 is a reply to message #51909] |
Fri, 21 June 2002 03:42  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
set this parameter
REMOTE_DEPENDENCIES_MODE=SIGNATURE
this is error is because of the change in the timestamp and signature of the dependent objects.
if any underlying objects of the function ( say a table is added with new column) the pl/sql program unit
need to be recompile to update its signature and dependency.
so on case of any of these erros, just recompile them.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
