XML

[abanic]

I'm using WebService methods to call stored-procedure (STP) which provide XML data for Delphi client application (use TClientDataSet and XMLTransformProvider)
Now, when in STP do right SELECT

select xmlelement(name mydata, xmlforest(ObjID, Name, Adress...) as mydata
from dba.Customer

then as XML result is like

<root>
<mydata><ObjID>1</ObjID><Name>John Smith</Name> ....
<mydata><ObjID>2</ObjID><Name>Maggie May</Name> ....
....
</root>



But when made a STP-call where i "calculate" SQL statement and execute it with

EXECUTE IMMEDIATE WITH RESULT SET ON sCreatedSQL;

then resulted XML looks in different form, like
<root>
<row expression="<mydata><ObjID>1</ObjID><Name>John Smith</Name>
<row expression="<mydata><ObjID>2</ObjID><Name>Maggie May</Name>
...
</root>

How to eliminate this "row expression="?!

Thnx
Angello