As I said already there're limits what kind of XML XmlAdapter can handle and it's covered in the help.
>that is understandable, I tried with xmladapter but get another error :
>xml parse error abstract element is not allowed in instance document. Of course the document is rather complex, but thats a real life situation, xmladapter doesnot suppose to be a toy, does it?
>
>
>>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.
>>
--sb--