CREATE or replace PROCEDURE HSG.testproc1(in tabname varchar(30))
begin
    execute immediate with result set on  'select * from '||tabname
end  


call HSG.testproc1('HSG.Person'); 


create or replace  PROCEDURE [HSG].[testproc2]
 (in @START_DATE int,
  in @END_DATE int,
  out @out_t varchar(1000) 
)   as
  BEGIN
  declare 
     @sqlstr varchar(1000),
     @fact_table  VARCHAR(50)
set @fact_table= 'HSG.Person'
set @sqlstr=' select id,name  into #data_table2 from ' || @fact_table
execute (@sqlstr)
execute HSG.testproc1('#data_table2')
end


call HSG.testproc2('1','b','') ;