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

Oracle Error Message

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

Reason for the Error

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.

Solution

None