>I need to read XML file with complex structure - it has several number of forms.
>XMLTOCURSOR() function failed with errror 2120 - Unable to infer XML schema.
>Please,Help!!!!
>I need to read XML file with complex structure - it has several number of forms.
>XMLTOCURSOR() function failed with errror 2120 - Unable to infer XML schema.
>Please,Help!!!!
XmlToCursor is not designed to read deeply nested XML. You can MAYBE shoehorn XMLAdapater to work with this schema you got but it's pretty complex and doesn't really map well to a cursor structure.
You'll probably be better off just manually parsing this document with the XMLDOM and picking out the pieces you actually need to work with...
+++ Rick ---