Home » Developer & Programmer » JDeveloper, Java & XML » Load XML into DataBase multiple XSD Schema (Oracle database 10g/11g)
Load XML into DataBase multiple XSD Schema [message #555586] Fri, 25 May 2012 05:10
ator
Messages: 43
Registered: March 2009
Member
Hi, i hope this is the right section Smile.
Before posting i've looked around internet and i couldn't find a solution to my problem.

This is the issue.
We have a XSD schema that refence to other 4 xsd schema for the structure.
For examples myXSD1.xsd which refence to myXSD2.xsd and myXSD3.xsd

The registration of the XSD goes smoothly and i do it as follow.
DBMS_XMLSCHEMA.REGISTERSCHEMA('http://www.myxsd.ch/xmlns/myXSD2.xsd',
           BFILEname('MY_TEMP','myXSD2.xsd'), TRUE, TRUE, FALSE, TRUE,
           csid => nls_charset_id('AL32UTF8'));

DBMS_XMLSCHEMA.REGISTERSCHEMA('http://www.myxsd.ch/xmlns/myXSD3.xsd',
           BFILEname('MY_TEMP','myXSD3.xsd'), TRUE, TRUE, FALSE, TRUE,
           csid => nls_charset_id('AL32UTF8'));

DBMS_XMLSCHEMA.REGISTERSCHEMA('http://www.myxsd.ch/xmlns/myXSD1.xsd',
           BFILEname('MY_TEMP','myXSD1.xsd'), TRUE, TRUE, FALSE, TRUE,
           csid => nls_charset_id('AL32UTF8'));


Then i create the table
CREATE TABLE MY_XML_TABLE OF XMLType
  XMLSCHEMA "http://www.myxsd.ch/xmlns/myXSD1.xsd"
  ELEMENT "rotmyXSD1";

INSERT INTO MY_XML_TABLE VALUES (XMLType(bfilename('MY_TEMP', 'myFile.xml')));


When i try to retrieve the value, all the value that are defined in the myXSD2 And myXSD3 schema are missing.
I hope i made my self clear enough because is already a week since is I got the problem.

Hope someone can help me Smile

Ator.

Previous Topic: Problem With Java Stored Procedure invoking Windows runtime process
Next Topic: XMLTABLE with xmlnamespaces XPST0005 issue
Goto Forum:
  


Current Time: Thu Mar 28 12:39:19 CDT 2024