Records with Double Quotes Are Rejected by SQL*Loader and an ORA-00904 Occurs with LKM SQLLDR
(Doc ID 2179119.1)
Last updated on SEPTEMBER 20, 2023
Applies to:
Oracle Data Integrator - Version 10.1.3.2.0 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
Symptoms
The following message is received in Oracle Data Integrator (ODI) when processing a file using the Oracle SQL*Loader (LKM File to Oracle):
Note an "ORA-00904 string: invalid identifier" message is received if trying to manually insert the record into the Oracle MYSCHEMA.MYTABLE table.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |