DECLARE GLOBAL TEMPORARY TABLE SESSION.MYTEMPTABLE (id INT) ;

DECLARE GLOBAL TEMPORARY TABLE SESSION.MYTEMPTABLE (id INT) ON COMMIT DROP TABLE;

create procedure test.testtmptable()
	DYNAMIC RESULT SETS  1 
begin
	begin
		DECLARE dummy INT;
		DECLARE CONTINUE HANDLER FOR SQLSTATE '42704' SET dummy =  1 ;
		
		DROP TABLE SESSION.testtable;
	end;

	begin
		declare global temporary table SESSION.testtable (id int) on commit preserve rows;

		begin
			declare c cursor with return for 
				select * from SESSION.testtable;
				
			insert into SESSION.testtable (id) values ( 1 );

			open c;
		end;
	end;
end@