set sql_mode='ORACLE,STRICT_TRANS_TABLES';
create table t1(c1 varchar2(10));
delimiter /
CREATE or replace procedure p3(b1 decimal(64,24))
AS
  strres VARCHAR(4);  
  CONTINUE HANDLER FOR NOT FOUND
  BEGIN
    NULL;
  END;
  CONTINUE HANDLER FOR SQLWARNING
  BEGIN
    NULL;
  END;
  EXIT HANDLER FOR OTHERS -- SQLEXCEPTION
  BEGIN
      ROLLBACK;  -- rollback any changes made in the transaction
      show warnings;
      RESIGNAL;  -- raise again the sql exception to the caller
  END;
BEGIN 
  start transaction;
  insert into t1 values('aaa');
  CREATE TEMPORARY TABLE IF NOT EXISTS wrk_rchtra(origine VARCHAR2(10) NOT NULL);
  commit;
END
/
call p3(1.0)
/
select * from t1
/
delete from t1;
/
call p3(1.0)
/
select * from t1
/
drop table t1
/
drop procedure p3
/
