[news.eclipse.birt] SQL results differences between BIRT 2.2.2 and BIRT

[Dragos <eu.dragos@xxxxxxxxx>]

Hello,

I have been working with BIRT 2.2.2 and created a report that connects 
to a MS SQL database and executes a stored procedure to return results.
The SP creates a temporary variable table and then runs some cursors to 
get data which it inserts into the temp table variable.
At the end of the SP, I just select field_name from @temp_table for the 
results.

SP structure:
------
ALTER PROCEDURE [dbo].[test_BIRT]

AS
begin
	Declare @var1 int
	Declare @var2 int
	
	declare @tmp table ( [id] [int] IDENTITY (1, 1) NOT NULL ,
   		url varchar(256),   clicks int, url_pro varchar(1000))

	Declare my_cursor CURSOR FOR
	select distinct(url)
		from clicks
	OPEN my_cursor
	FETCH NEXT FROM my_cursor into  @var1
	WHILE @@FETCH_STATUS = 0
		Begin
			<<code>>

			insert into @tmp(url, clicks, url_Pro)
				values('Link: ' + @var1,  @var2, @var3)

			<<code>>
	
	select  url, clicks, url_Pro from @tmp
end
------

I have switched to using BIRT 2.3 and the same SP now does not return 
any results at all.  I get a "Total 0 record(s) shown" in the results 
preview and nothing when actually using the dataset.

I understand that BIRT should be only able to handle "simple" stored 
procedures however that the same SP returns results in BIRT 2.2.2 and 
not in BIRT 2.3.

Has somebody else ran into this kind of issue?