Oracle Error Message
PLS-00245: Formals used in the ‘parameters’ clause must appear exactly once
Reason for the Error
There are multiple declarations of the formal parameter in the PARAMETERS clause. PL/SQL allows only one declaration of the formal parameter in the PARAMETERS clause.
Solution
Correct the PARAMETERS clause.