HOW TO RETRIEVE VALUE FROM TEMP TABLE ON THE INTERFACE

["Vasudeva, Rahul" <rahul(dot)vasudeva(at)capgemini(dot)com>]

Hi,

 

    I am executing a stored procedure from an ASP page without any input parameters, in that stored procedure two sql queries are executed and the result is stored in a temporary table, now I want to retrieve the recordset of that temp table on the interface.

 

There is an error every time on the Interface “Invalid Object”  , although I am dropping the temp table explicitly ..

 

Thanks & Regards

Rahul Vasudeva.

 

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.