Oracle Error PLS-00528: The parameters to an ORDER function must have IN mode

Oracle Error Message

PLS-00528: The parameters to an ORDER function must have IN mode

Reason for the Error

You declared parameter to an ORDER function to have OUT or IN OUT mode.

Solution

Correct the parameter to use IN mode only.