if exists(select 1 from sysprocedure where proc_name='temp_table_exists') then
    drop function temp_table_exists;
end if;

create function temp_table_exists( temptable varchar(128) )
returns int
not deterministic
begin
    declare ret int;
    set ret = 1;
    BEGIN
        EXECUTE IMMEDIATE 'delete from '+temptable+' where 0=1';
        EXCEPTION WHEN OTHERS THEN SET ret=0;
    END;
    return ret;
end;

create table #ma_temp_table( id int not null default autoincrement, name char(100) not null, primary key (id) )
--select * from #ma_temp_table
select temp_table_exists('#ma_temp_table') from dummy
--return 1
drop table #ma_temp_table
select temp_table_exists('#ma_temp_table') from dummy
--return 0