I have the following SQL*Loader file
LOAD DATA
CHARACTERSET UTF8
INFILE *
APPEND
INTO TABLE CCD
(
CCDID constant 3
,ccd.xsd filler char(200)
,CCD_DOC LOBFILE(ccd.xsd) TERMINATED BY EOF
)
BEGINDATA
ccd.xsd
This worked wonderfully back when I first built it with all the same files, etc. I actually got help from this very forum to create this file from
965626 Only now when I run it I am getting the following error
SQL*Loader-418:
Bad datafile datatype for column CCD_DOC
That's all the log says. The xml file checks out fine. I haven't made a single change to that file. I did alter the SQL*Loader file to append rather than truncate but that shouldn't effect this, should it? I am using 11.1.0.7.0. Does anyone have any idea what could be going wrong here? Even an idea of where I should look to figure it out would be helpful.
Thank you!
Eva