OraFAQ Forum: Server Utilities » ORA-19032 Expected XML tag but go no content

Home » RDBMS Server » Server Utilities » ORA-19032 Expected XML tag but go no content (Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

[Message index]

		ORA-19032 Expected XML tag but go no content By: nittejoy on Mon, 04 March 2019 01:13
		Re: ORA-19032 Expected XML tag but go no content By: Michel Cadot on Mon, 04 March 2019 02:50

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 19:23:39 CDT 2024