blacklistcrew
New Member
I get the following XML from a request:\[code\]<records> <record> <field name="code" value="http://stackoverflow.com/questions/10823420/1"/> <field name="dexcription" value="http://stackoverflow.com/questions/10823420/MyName"/> <field name="id" value="http://stackoverflow.com/questions/10823420/666"> </record> <record> <field name="code" value="http://stackoverflow.com/questions/10823420/2"/> <field name="dexcription" value="http://stackoverflow.com/questions/10823420/MyName"/> </record> ...</records>\[/code\]The first record was processed successfully, returning the element "id"; the second was not, and so returned without this element.I need to write an XML SQL query based returning these two columns ("code" and "id"), but only records that were processed successfully. I tried to use XMLType, but it still fails. Can anyone help me?Thanks in advance, and sorry for my "googled" English.