Hi, i hope this is the right section 
.
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
Ator.
] 
Blog
Search
Help
Members
Register
Login
Home
