On 15-04-15 17:19, Dmitry Baranov wrote: > Sorry Bert ) I had to explain that Oracle 11 is a business requirement, not a > hardware limitation. > >> Just do it, and then it should run fine, although you have to change the >> XML-Schemas (a bit) before registering them to Oracle. I already >> explained to you before what and why. > I remember your advise but not sure that changing all the sequences to > choices is a right way for many reasons. And I'm almost sure that it's an > Oracle bug since other XSD validation tools (visual studio, netbeans and > eclipse) say that my instance files are all OK and conform to XML schema.
You are right it is a messy solution, but if you use "sequence", like it is defined in the XML Schema, you have to take care that all the nodes in your XML are in the right/defined order. I think this is hard to achieve when XML-files are created in production, but of course, you can arrange that as an alternative. I think it is a stupid rule in the XML-Schema standard. The only alternative is "choice", but then you are not able to have the counting of the elements validated. Check the book written by Priscilla Walmsley, she is the all knowing saint regarding XML Schema. If you don't have it, you can check the w3-website, where the standard is published, but less comfortable to read. So, validating completely against XML Schema is not feasible because of weakness in the XML-Schema standard. So why should you then register the XML-Schema in the database? There is another reason for that, and that is because Oracle is able to optimize the querying by using the structures in the XML-Schema. And for that purpose, replacing the "sequence" with "choice" is not a problem. I don't know if comparing the results with other products is a reason to say that your work is done right. You should always follow the standard in your analyses, before you declare one product buggy and another not. There is a message on Oracle forum, similar symptoms - https://community.oracle.com/message/10778556 I see in that message that there was a patch recommended, did you try that? Always use the latest patch level. > > > Ok, I'll try 12c this night, thanks. Maybe on success, you are able to change the business requirement. good luck. Bert
