But even if that does work, is there any guarantee that the query would be starting afresh for each new file? Becoz i need to do that. I need the query to execute through each xml file in a directory (even under subdirectories of this directory). but it should consider each file as a new beginning. any help on this would be most welcome. please? Thanks a million anyways. :)