create PROCEDURE test()
BEGIN
DECLARE p_sqlcode VARCHAR(50) ;
DECLARE p_sqlcode2 VARCHAR(50) ;
DECLARE p_status_message VARCHAR(50) ;
DECLARE duplicate_key CONDITION FOR 1062 ;
declare v_etl_dt date;
set v_etl_dt=sysdate();
DECLARE CONTINUE HANDLER FOR duplicate_key
BEGIN
SET p_sqlcode=1062;
set p_sqlcode2='3';
SET p_status_message='Duplicate key error';
END;
insert into departments values ('公寓1','11','北京',v_etl_dt);
select p_sqlcode2,p_sqlcode,p_status_message from dual;
end;