XML parsing problems....
Date: Tue, 5 May 2020 14:57:41 -0400
Message-ID: <CAFQ5ACLqHTXutkHW4qMZ-c1XrsEiTBSrVxmJ-V2Cs8rJ0JvoYA_at_mail.gmail.com>
Hi all,
I've recently been experiencing a problem w/ XML parsing. This is on Oracle Database 19c 19.7.0.0.0 Standard Edition.
We have a pretty complex process, but I was able to whittle it down to a simple, reproducible test case. (I should mention, I'm *really* not an XML guy, at all!)
Basically, it comes down to this:
Simple PL/SQL function that defines a CLOB and an XMLType. Poplate the
CLOB w/ some XML, then call xmltype() function to convert to and store in
the XMLType column.
First, I ran into ORA-64498 "FTP and HTTP access over XDB repository is not allowed on server side". I had no idea what that meant, so I opened an SR. As it turns out, we are (apparnetly) getting this error due to the http access in the DTD. So, I set event 31156 to level 2, to disable DTD validation. That got me past the ORA-31156, but then I was getting a LPX-00225: end-element tag "HEAD" does not match start-element tag "META". Well, upon closer examination, sure enough, I was missing a '</META>' tag. I added that in, and now I have a LPX-00210: expected '=' instead of 's'. I have no idea what this error means or how to fix it.
Any insights would be greatly appreciated.
-Mark
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 05 2020 - 20:57:41 CEST