ORA-19032 Expected XML tag but go no content [message #675016] |
Mon, 04 March 2019 01:13 |
|
nittejoy
Messages: 4 Registered: December 2012 Location: India
|
Junior Member |
|
|
Hello,
I have table in Oracle 12c Database which has culumn with XMLType datatype.
From SQL loader while trying into null value, I get below error.
Record 1: Rejected - Error on table "TNAMNE"
ORA-19032 : Expected XML tag, got no content.
MY SQL loader looks like this:
LOAD DATA
INFILE 'file.ldr' "str x'594F594F454F4C0A"
COUNTINUEIF NEXT(1:1) = '#'
INTO TABLE tablename
FILEDS TERMINATED BY'|'
OPTIONALLY ENCLOSED BY '"' AND '"'
TRAILING NULLCOLS (
"col1",
....
"EXTENTION_XML" CHAR(2000)
)
In my input file for EXTENTION_XML I have null vale. While executing sql loader I am getting ORA-19032 Error. How to fix this ?
Regards,
Joy
|
|
|
|