If you don't get records, it's probably because of a parallel query. Change the where clause to look at the ecid as well.

where spid=(yourspid) and ecid=0