Oracle Message PLS-00381 - type mismatch found at string between column and variable in subquery or INSERT

ERRORtype mismatch found at string between column and variable in subquery or INSERT
CAUSEThe datatypes of a column and a variable do not match. The variable was encountered in a subquery or INSERT statement.
ACTIONChange the variable datatype to match that of the column.