Does the Migration Workbench support the conversion of T/SQL stored procedures that return multiple result sets?
The Migration Workbench creates a single cursor variable in an OUT argument in the Oracle Server and uses that variable for all the converted result set SELECT statements. This causes only the results of the last SELECT statement that was opened to be returned in the cursor variable. The results of all other SELECT statements are lost. To prevent the loss of SELECT statement results, create a separate cursor variable argument for each result set SELECT statement and open each cursor variable using a separate SELECT statement. Alternatively, you can use Oracle packages. Before you can use Oracle packages to prevent the loss of SELECT statement results, you must comment out all result sets to ensures that the Migration Workbench does not attempt to parse them: create procedure test as declare @x varchar(10) select @x = “[Customer]” select @x /*result set*/ select * from ln_display where ptid >1 /*result set with multiple rows*/ To implement the work-around using Oracle packages: Create a
