Oracle Error PLS-00381: type mismatch found at ‘string’ between column and variable in subquery or INSERT

Oracle Error Message

PLS-00381: type mismatch found at ‘string’ between column and variable in subquery or INSERT

Reason for the Error

The datatypes of a column and a variable do not match. The variable was encountered in a subquery or INSERT statement.

Solution

Change the variable datatype to match that of the column.