PLS Database Error Messages

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

oracle

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: Provide a select list element of compatible type.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/