Records with Double Quotes are Rejected by SQL*Loader, and ORA-00904 is Received in ODI when LKM SQLLDR is Used (Doc ID 2179119.1)

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.

Symptoms

The following message is received in Oracle Data Integrator (ODI) when processing a file using the Oracle SQL*Loader (LKM File to Oracle):

ERROR Record 1: Rejected - Error on table MYSCHEMA.MYTABLE, column ACOLUMN.
no terminator found after TERMINATED and ENCLOSED field

The record from the text file producing the error is:

COLUMN1,COLUMN2,ACOLUMN,COLUMN4

115370,37507,"Van Ameyde"(test)"","IT1216.0000.0255.5-001"

Note an "ORA-00904 string: invalid identifier" message is received if trying to manually insert the record into the Oracle MYSCHEMA.MYTABLE table.

Cause

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