ORA-30951: Element or attribute at Xpath references exceeds maximum length
I am attempting to import an xml file into the repository and have it shred into the object-relational tables. I think the install, security, and configuration are working now. I registered a schema and it created object-relational xml_tables, triggers, and types. The full xml file is > 80MB and causes the error below. XDB created all the fields as VARCHAR2(4000).
I would guess that some of the fields have max lengths > 4000. I plan to annotate the schema with SQLType="CLOB", but need to know which fields to change. I was able to copy the xml file and reduce that xml file to one record, which imported into the tables. My plan was to write a view over the xmltables to get the lengths of certain fields.
I would guess that some of the fields have max lengths > 4000. I plan to annotate the schema with SQLType="CLOB", but need to know which fields to change. I was able to copy the xml file and reduce that xml file to one record, which imported into the tables. My plan was to write a view over the xmltables to get the lengths of certain fields.
0