Birt and Stored Procedure problem

hesp

I use SQL Server 2005 and Birt for generating reports. I have stored procedure with one input parameter and temporaty table in stored procedure:

stored_procedure_name
@id int
begin
select ....
into #temp

update #temp.......

update #temp.......


select id, name from #temp
end

I use stored procedure dataset from Birt. When DataSet call stored procedure error is displayed: "not found object #temp". What is problem?

Please!