Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Registering XML Schema with CLOB element

572728
Member Posts: 183
Dear All,
I am trying to register an XML-Schema with an element of type CLOB.
Previously it was STRING and it was not a problem.
But the data for this element has drastically increased and so I am now trying to register the schema with a CLOB column.
The below is the schema.
begin dbms_xmlschema.registerSchema(
'test.xsd',
XMLType('<?xml version="1.0" encoding="ISO-8859-1" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns="http://www.DMexample.com/ldb2xmlfile.xsd"
xmlns:xdb="http://xmlns.oracle.com/xdb"
targetNamespace="http://www.DMexample.com/ldb2xmlfile.xsd" version="1.0"
elementFormDefault="qualified">
<xs:element name="XMLDATA" type="LDB2XMLFILE"/>
<xs:complexType name="LDB2XMLFILE">
<xs:sequence>
<xs:element name="XMLSSDDATA">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="SSDDATA">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="ADV-FORMULA" xdb:SQLType="CLOB"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>'), TRUE, TRUE, FALSE, FALSE);
end;
But I am getting an error (ORA-31094 Incompatible sql type "CLOB" for attribute or element "ADV-FORMULA")
Can anyone help me out in registering this schema.
Appreciate any help.
Thanks & Regards
Madhu K
I am trying to register an XML-Schema with an element of type CLOB.
Previously it was STRING and it was not a problem.
But the data for this element has drastically increased and so I am now trying to register the schema with a CLOB column.
The below is the schema.
begin dbms_xmlschema.registerSchema(
'test.xsd',
XMLType('<?xml version="1.0" encoding="ISO-8859-1" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns="http://www.DMexample.com/ldb2xmlfile.xsd"
xmlns:xdb="http://xmlns.oracle.com/xdb"
targetNamespace="http://www.DMexample.com/ldb2xmlfile.xsd" version="1.0"
elementFormDefault="qualified">
<xs:element name="XMLDATA" type="LDB2XMLFILE"/>
<xs:complexType name="LDB2XMLFILE">
<xs:sequence>
<xs:element name="XMLSSDDATA">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="SSDDATA">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="ADV-FORMULA" xdb:SQLType="CLOB"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>'), TRUE, TRUE, FALSE, FALSE);
end;
But I am getting an error (ORA-31094 Incompatible sql type "CLOB" for attribute or element "ADV-FORMULA")
Can anyone help me out in registering this schema.
Appreciate any help.
Thanks & Regards
Madhu K
This discussion has been closed.