sqlloader with xml file: Initial enclosure character not found
451460Apr 11 2006 — edited May 16 2006I'm trying to load a file with xml defnitions like this:
I just want values a,b,c into table halba(kolom)
<halba>
<rij><kolom>a</kolom></rij>
<rij><kolom>b</kolom></rij>
<rij><kolom>c</kolom></rij>
</halba>
With control file like:
infile 'halba.xml' "str '</rij>'"
into table halba
append
( kolom char(100) enclosed by "<kolom>" and "</kolom>"
)
I have tryed several thinks but the log file keeps me telling:
SQL*Loader: Release 9.2.0.6.0 - Production on Tue Apr 11 09:15:22 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: halba.ctl
Data File: halba.xml
File processing option string: "str '</rij>'"
Bad File: halba.bad
Discard File: none specified
(Allow all discards) Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct Table HALBA, loaded from every logical record.
Insert option in effect for this table: APPEND Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
KOLOM FIRST 100 CHARACTER
First enclosure string : '<kolom>'
Second enclosure string : '</kolom>' Record 1: Rejected - Error on table HALBA, column KOLOM.
Initial enclosure character not found
Record 2: Rejected - Error on table HALBA, column KOLOM.
Initial enclosure character not found
Record 3: Rejected - Error on table HALBA, column KOLOM.
Initial enclosure character not found
Record 4: Rejected - Error on table HALBA, column KOLOM.
Initial enclosure character not found Table HALBA:
0 Rows successfully loaded.
4 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null. Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576 Total logical records skipped: 0
Total logical records read: 4
Total logical records rejected: 4
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 0
Total stream buffers loaded by SQL*Loader load thread: 0 Run began on Tue Apr 11 09:15:22 2006
Run ended on Tue Apr 11 09:15:23 2006 Elapsed time was: 00:00:00.24
CPU time was: 00:00:00.08