set sql_mode='ORACLE,STRICT_TRANS_TABLES';
delimiter /
CREATE or replace procedure p4()
AS
  CONTINUE HANDLER FOR SQLWARNING
  BEGIN
    NULL;
  END;
  EXIT HANDLER FOR OTHERS -- SQLEXCEPTION
  BEGIN
      GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE, @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
      SELECT @sqlstate, @errno, @text;
      SHOW WARNINGS;
      RESIGNAL;  -- cause DBG_ASSERT failed
  END;
BEGIN 
  CREATE TEMPORARY TABLE IF NOT EXISTS wrk_rchtra(origine VARCHAR2(10) NOT NULL);
END
/
call p4()
/
call p4()
/
drop procedure p4
/
