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 next 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


Re: ORA-19032 Expected XML tag but go no content [message #675017 is a reply to message #675016] Mon, 04 March 2019 02:50 Go to previous message
Michel Cadot
Messages: 66636
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From your previous topic:

John Watson wrote on Thu, 20 December 2012 08:37
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read
...

ORA-19032: Expected XML tag %s got %s
 *Cause: When converting XML to object, a wrong tag name was present
 *Action: Pass a valid canonical XML that can map to the given object type
Previous Topic: SQL Loader for XML File
Next Topic: I can't export all tables
Goto Forum:
  


Current Time: Tue Oct 15 01:17:27 CDT 2019