473,320 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Error 0RA-30937: Error is Comming While Inserting into an XML Type Table

Dear Forum Members,
I have generated an XML Schema and a Table of XMLType referencing the XML Schema.
Now When I am Inserting the Data into the Table.
I am getting the Error 0RA-30937: Error is Comming.

I am pasting the Code which I have written.
Appreciate any Help...

[HTML]begin dbms_xmlschema.registerSchema(
'http://www.robertboschindia.com/example.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/example.xsd"
targetNamespace="http://www.DMexample.com/example.xsd" version="1.0"
elementFormDefault="qualified">

<xs:complexType name="LDB2XMLFILE">
<xs:sequence>
<xs:element name="XMLSSDDATA">
<xs:complexType>
<xs:sequence>
<xs:element name="LabelList">
<xs:complexType>
<xs:sequence>
<xs:element name="SSDDATA">
<xs:complexType>
<xs:sequence>

<xs:element name="Labelname" type="xs:string"/>
<xs:element name="KEY" type="xs:integer"/>
<xs:element name="FINISHED" type="xs:string"/>
<xs:element name="CONTACTNUMBER" type="xs:string"/>
<xs:element name="DEFAULT" type="xs:string"/>
<xs:element name="MIN" type="xs:integer"/>
<xs:element name="MAX" type="xs:integer"/>
<xs:element name="UNIT" type="xs:string"/>
<xs:element name="FORMULA" type="xs:string"/>

</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>

</xs:sequence>
</xs:complexType>

<xs:element name="XMLDATA" type="LDB2XMLFILE"/>

</xs:schema>'), TRUE, TRUE, FALSE, FALSE);
end;


[/HTML]
-- Creating the Table
CREATE TABLE LDB2_XMLFILE OF XMLType
XMLSCHEMA "http://www.robertboschindia.com/example.xsd"
ELEMENT "XMLDATA";


--Inserting into Table
[HTML]
insert into LDB2_XMLFILE
values(XMLType('<?xml version="1.0" encoding="ISO-8859-1"?>
<XMLDATA xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.DMexample.com/example.xsd"
xsi:schemaLocation="http://www.DMexample.com/example.xsd http://www.boschindia.com/example.xsd">
<XMLSSDDATA>
<LabelList>
<SSDDATA>
<Labelname>This is Lable</Labelname>
<KEY>123</KEY>
<FINISHED>This is Finished data</FINISHED>
<CONTACTNUMBER>This is Contact Number </CONTACTNUMBER>
<DEFAULT>This is default </DEFAULT>
<MIN>1</MIN>
<MAX>3</MAX>
<UNIT>This is Unit </UNIT>
<FORMULA>tHIS IS FORMULA</FORMULA>
</SSDDATA>
</LabelList>
</XMLSSDDATA>
</XMLDATA>')
);
[/HTML]
-- Getting Error
ORA-30937: No schema definition for 'XMLSSDDATA' (namespace 'http://www.DMexample.com/example.xsd') in parent '/XMLDATA'


Regards
Madhu K
Jul 6 '07 #1
1 2603
Dököll
2,364 Expert 2GB
Have to admit, I have not yet seen this error. Please give link a go, see what you can pull up. Just in case this is related to your previous post: http://www.w3schools.com/schema/schema_howto.asp
Jul 10 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

61
by: norb1 | last post by:
After tracking down a bug in my Fortran program, I found that it assumed max(NaN,0.) = 0. This makes no sense, as the outcome of the operation is undefined and should be NaN. max(NaN,0.) = NaN...
66
by: prady | last post by:
hi all, could any one solve the following C program. If any one knows the answer please post it Ques: A C function that will print 1 to N one per each line on the stdout , where N is a int...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.