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