Sql Get Result Set From Stored Procedure. Copying a SQL Server Stored Procedures Results Set to a Local Temp Table. Therefore in the case of a SQL CLR stored procedure the stored procedure code itself is essentially placed in a wait state after executing the CLOSE cursor statement.
There was a recent question asked on Stack Overflow. DB2 101 and Oracle 11g R2. Copying a SQL Server Stored Procedures Results Set to a Local Temp Table.
In Oracle you can use SYS_REFCURSOR type to pass result sets between stored procedures.
We will be using INSERT INTO and EXEC command to retrieve the values and insert into temporary table. After the caller consumes the corresponding result set that is it FETCHes until SQLCODE100 control is then returned back to the SQL CLR stored procedure which can then execute additional code. This feature allows us to modify the column names and column data types of the result sets returned by a stored procedure without actually modifying the stored procedure code. Copying a SQL Server Stored Procedures Results Set to a Local Temp Table.