Srikkanth Mohanasundaram wrote:Yes you are right. It does some delete of temporary tables. So how would i get the resultsets , is it not possible?
I would think it is possible. How to do so varies by database though. Conceptually, the stored procedure accumulates the result sets and returns them.