>There is 24k records in the result cursor. Everything works fine before and suddenly it takes a long time (like 8 seconds). I don't think it's normal.
Nothing unusual about that. The XMLTOCURSOR() internaly uses XMLDOM to process XML which loads the whole XML DOM into a memory. The time of processing grows exponentially with # of records in the XML.
--sb--