Home » RDBMS Server » Server Utilities » ORA-19032 Expected XML tag but go no content (Oracle 12c)
ORA-19032 Expected XML tag but go no content [message #675016] Mon, 04 March 2019 01:13 Go to previous message
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


 
Read Message
Read Message
Previous Topic: SQL Loader for XML File
Next Topic: I can't export all tables
Goto Forum:
  


Current Time: Tue Jan 21 06:11:06 CST 2020