These are records that are being transferred from a customers IT dept into another application that my company has written. Its a one time data transfer with smaller updates after that...
Harold


>Yes, 30K ;) Seriously, the performance of XMLTOCURSOR () degrade exponentially as the size of the XML grow. The real question is, why do you need to pass 30K records? That seem a lot to me.
>
>>I am using XMLTOCURSOR to import records...The command works fine up to about 30k records and then hangs the machine after that... Are there some practical upper limits to the number of records that can be imported via XMLTOCURSOR()???