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

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

Cause: In 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.

Action: none