Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-16793: Logical Standby Database Guard is unexpectedly OFF

1 Answers  


SQL*Loader-00952: Error calling once/data file initialization

1 Answers  


ORA-29318: datafile string is online

1 Answers  


ORA-32109: invalid column or parameter position

1 Answers  


RMAN-06033: channel string not allocated

1 Answers  






ORA-36402: (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.

1 Answers  


ORA-26052: Unsupported type number for SQL expression on column string.

1 Answers  


IMG-02010: 2FF10 - illegal image format specification

1 Answers  


LSX-00164: no content specified in "~S"

1 Answers  


ORA-14027: only one PARTITION clause may be specified

1 Answers  


ORA-01655: unable to extend cluster string.string by string in tablespace string

1 Answers  


DRG-11801: Continue

1 Answers  






Categories