this is for a oneway transfer. I just wanted to actually check out the data as a cursor rather than in xml befor handing it over to the Vendor

in any other cases i use xmltocursor i just shuttle a few data and never had problems

As always thanks a lot for your excellent help

Peter
PS.:

btw i really liked Hawaii!! in May

ill be off ti thailand tonight and then to Austria




>If this is for one time data transfer then I don't think that performance should be an issue. Especially since generating the data should be fast - it's the reading of XML back into data that's generally slow because of the DOM access.
>
>But for back and forth data transfers XML data should not be enormously large. If you do need to shuttle lots of data, it's better to break it up into smaller chunks and send that or do atomic updates. That way the DOM tree stays small and performance is much better.
>
>+++ Rick ---
>