Hi, I am trying to use the XML Schema Evolution, and hit a roadblock. I'm using 19C, and have a table with an XMLTYPE column, with a registered schema. I wrote a diffxml XML that achieves the updates wanted (addition of numerous optional attributes). First roadblock was the size of it. Because it was too big for xPath, I had to run the XDB.DBMS_XMLSCHEMA.inPlaceEvolve in chunks (the diffXML data was about 60,000 characters). It worked, but hit another roadblock with an error thrown for a specific node:
ORA-30951: Element or attribute at Xpath /schema/element[1]/complexType/sequence/element/complexType/sequence/element/complexType/annotation/appinfo[1][@] exceeds maximum length
I think it comes from Oracle (or SQL Developer) running queries to insert/update this section:
<xs:annotation>
<xs:appinfo>
<csx:kidList xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xdb="http://xmlns.oracle.com/xdb">
That has 105 elements <csx:kid>. I think that xPath cannot handle all the characters taht this update requires.
Any Thoughts on how to go around this issue?