调用
call get_sto_seqnum('V',@a);
select @a;
参数:in P_CODE VARCHAR(12), out NEW_ORDER_ON VARCHAR(14) (P_CODE 传入类型 )
类型:PROCEDURE
BEGIN
DECLARE p_NewValue VARCHAR(20);
DECLARE p_CurrentDate VARCHAR(8);
DECLARE p_Prefix VARCHAR(5);
DECLARE p_MaxIndex INTEGER;
DECLARE p_MaxDate VARCHAR(8);
DECLARE p_MaxValue INTEGER DEFAULT 0;
DECLARE p_isOverflow INTEGER;
DECLARE p_Count INTEGER DEFAULT 1;
DECLARE s_no INTEGER DEFAULT 1;
DECLARE t_error INTEGER DEFAULT 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error = 1;
START TRANSACTION;
SELECT
prefix,max_date,max_index
INTO p_Prefix,p_MaxDate,p_MaxIndex
FROM sto_sequence_number
WHERE prefix=P_CODE limit 1 for UPDATE;
set p_MaxValue =