Oracle Error PLW-05003: same actual parameter(string and string) at IN and NOCOPY may have side effects

Oracle Error Message

PLW-05003: same actual parameter(string and string) at IN and NOCOPY may have side effects

Reason for the Error

The indicated parameter was declared with the NOCOPY hint in the subprogram specification but not in the body, or it was declared with the NOCOPY hint in the body but not in the specification.

Solution

Ensure that the specification and the body agree in their use of NOCOPY. If this mismatch is not corrected, the program will obey the declaration given in the specification, ignoring that in the body.