Oracle Error PLS-00382: expression is of wrong type

Oracle Error Message

PLS-00382: expression is of wrong type

Reason for the Error

An expression has the wrong datatype for the context in which it was found.

Solution

Change the datatype of the expression. You might want to use datatype conversion functions.