Message Oracle PLS-00517 - Type mismatch between a select list element string and corresponding table column in INSERT statement with a subquery

ERRORType mismatch between a select list element string and corresponding table column in INSERT statement with a subquery
CAUSEIn an INSERT statement with subquery, at lease one of the elements of the select list was not type-compatible with the corresponding column of the table in the INTO clause. This error indicates that the subquery should be rewritten to match the structure of the target table.
ACTIONNone