PLS-00517: Type mismatch between a select list element
'string' and corresponding table column in INSERT statement
with a subquery
- 1 Answers
- 2643 Views
- I also Faced
- E-Mail Answers
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 |
NZE-28754: object storage failure
ORA-22807: cannot resolve to a scalar type or a collection type
ORA-22977: missing or invalid attribute
ORA-28119: policy group does not exist
DRG-10841: invalid SCORE argument supplied to FUZZY
UDE-00050: Unable to setup parameter processing.
ORA-16137: No terminal recovery is required
ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
ORA-01039: insufficient privileges on underlying objects of the view
ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
TNS-01000: spawn [<listener_name>] <spawn_alias> [<(ARGUMENTS='arg0, arg1,...')>]
LPX-00114: element "~1S" attribute "~2S" has invalid enumeration value "~3S"
Oracle Errors 
