I need to insert values into tables. I am doing it using sqlloader. Evrything is going fine, except the columns with CLOB datatype. I am unable to insert them, I am getting an error. This is the code I wrote:
[code=oracle]
load data
infile *
insert into table statusof_sites
fields terminated by ',' optionally enclosed by '"'
Trailing Nullcols
(id,
dc,
df,
cid,
lob_file FILLER char,
csc_configurati on LOBFILE(lob_fil e) TERMINATED BY EOF)
BEGIN DATA
1, hd, gh , ACME, C:\cntrl\xyz.tx t
ERROR:
LOB_FILE NEXT * , O(") CHARACTER
(FILLER FIELD)
CSC_CONFIGURATI ON DERIVED * EOF CHARACTER
Dynamic LOBFILE. Filename in field LOB_FILE
SQL*Loader-460: Column (CSC_CONFIGURAT ION), form of use (1) does not match char set id of (31)
[/code]
What should I do now? And what should be the data format in infile, if we specify the path externally like
infile 'C:\cntrl\xyz.c tl'
Please help me...
[code=oracle]
load data
infile *
insert into table statusof_sites
fields terminated by ',' optionally enclosed by '"'
Trailing Nullcols
(id,
dc,
df,
cid,
lob_file FILLER char,
csc_configurati on LOBFILE(lob_fil e) TERMINATED BY EOF)
BEGIN DATA
1, hd, gh , ACME, C:\cntrl\xyz.tx t
ERROR:
LOB_FILE NEXT * , O(") CHARACTER
(FILLER FIELD)
CSC_CONFIGURATI ON DERIVED * EOF CHARACTER
Dynamic LOBFILE. Filename in field LOB_FILE
SQL*Loader-460: Column (CSC_CONFIGURAT ION), form of use (1) does not match char set id of (31)
[/code]
What should I do now? And what should be the data format in infile, if we specify the path externally like
infile 'C:\cntrl\xyz.c tl'
Please help me...
Comment