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

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...