The XMLTOCURSOR() function doesn't support complex XML. It is designed to process asimple XML created by CURSORTOXML or similar. You may take a look at XmlAdapter but that is no guaranty that it'll support that XML either in which case you'll have to use XMLDOM to process it.
>I am trying to use xmltocursor for a standard xml file ( actually the schema + xml proposed by Un. Nations to replace edi) but I am getting the error : Unable to infer XML schema. (Error 2120)
>
>The xml + XML Schema is the UNeDOCS Standard.
>
>You can get all the info to the following link (There are several XML Formats for international transportation/logistic available, I am tryinmg to use the xml for the forwarding instructions).
>
>
http://www.unece.org/etrades/unedocs/V04/index.htm.
>
>The problem is that even though I have get all the sample xmls + shema foxpro cannot parse the xml.
>
>
>The question is how can I find out where is the problem is such cases. Is there a way to debug a complicated xml?
>
--sb--