CREATEORREPLACEPROCEDURE DLX.SP_E_EMPINFO_ADD_V1(
IN ID CHARACTER(8),
IN NAME VARCHAR(50),
IN SEX CHARACTER(1),
IN AGE CHARACTER(4),
IN TELNUM varchar(11),
IN BIRTHDAY CHARACTER(12),
IN EMADD VARCHAR(255),
IN SALARY VARCHAR(20),
OUT pRtCode INTEGER
)
SPECIFIC DLX.SP_E_EMPINFO_ADD_V1
LANGUAGESQLBEGIN
--异常处理
DECLARE SQLCODE INTEGER;
DECLARE EXIT HANDLERFOR SQLEXCEPTION SET pRtCode = SQLCODE;SET pRtCode = -1;
IF ID = '