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 c..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13639: The current operation was interrupted because it timed out.

1 Answers  


ORA-19582: archivelog file header validation for string failed

1 Answers  


ORA-01969: You must specify RESETLOGS or NORESETLOGS

1 Answers  


ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option

1 Answers  


ORA-13269: internal error [string] encountered when processing geometry table

1 Answers  






ORA-01059: parse expected before a bind or execute

1 Answers  


DRG-11004: duplicate or conflicting value for string

1 Answers  


ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

2 Answers  


ORA-16094: database shutdown during archival operation

1 Answers  


NID-00122: Database should have no offline immediate datafiles

1 Answers  


ORA-19200: Invalid column specification

1 Answers  


ORA-02151: invalid tablespace name: string

1 Answers  


Categories