Records with Double Quotes are Rejected by SQL*Loader, and ORA-00904 is Received in ODI when LKM SQLLDR is Used
Last updated on MAY 12, 2017
Applies to:Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.
The following message is received in Oracle Data Integrator (ODI) when processing a file using the Oracle SQL*Loader (LKM File to Oracle):
no terminator found after TERMINATED and ENCLOSED field
The record from the text file producing the error is:
Note an "ORA-00904 string: invalid identifier" message is received if trying to manually insert the record into the Oracle MYSCHEMA.MYTABLE table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms