How to fix the Oracle error PLS-00312: a positional parameter association may not follow a named association?

In this post, you’ll learn more about the Oracle ErrorPLS-00312: a positional parameter association may not follow a named association with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error PLS-00312: a positional parameter association may not follow a named association

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.

How to fix the Error PLS-00312: a positional parameter association may not follow a named association ?

You can fix this error in Oracle by following the below steps

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