I'm trying to load a comma delimited flatfile into a database, which contains a CLOB column and am getting an error. Please help if you can! Here's what my control file looks like:
INTO TABLE "HUB_STORE"
FIELDS TERMINATED BY ','
I get the error message:
SQL*Loader-350: Syntax error at line 18.
Expecting field-name, found keyword data.
As this is my first time loading data into a database using SQL*Loader, I'm at a loss. The CLOB column can be very large in some cases as it's basically an XML document within that column. Can anyone enlighten me as to what exactly the problem and possible solution are?
You might have to add a filler field.
RES_FILE FILLER CHAR
See the following links for more info on loading LOB data:
http://otn.oracle.com/docs/products/.../ch04.htm#8383 (for examples)
it seems like error is due to u r using reserved 'DATA'
in ur fields
DATA, (perhaps error is due to this on)
change the name of field as DATA1 in table and in control file
PSoni is right, DATA is one of the SQL LOADER RESERVEd words.
You won't see this error if you're just using SQL/PLSQL.
Click Here to Expand Forum to Full Width