PLS-00517

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

Causa: 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.

Acción: Provide a select list element of compatible type.