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

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

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

Action: Change the variable datatype to match that of the column.