Oracle Error PLS-00312: a positional parameter association may not follow a named association

Oracle Error Message

PLS-00312: a positional parameter association may not follow a named association

Reason for the Error

When a list of parameters is passed to a subprogram or cursor, if both positional and named associations are used, all positional associations must be placed in their declared order and before all named associations, which can be in any order.

Solution

Reorder the parameter list to meet the requirements or use named association only.