create or replace procedure BRH_SEQ_GENERATOR(appType in VARCHAR, bizType in VARCHAR, seqNo out varchar) is
begin
select t.current_value || appType || bizType || LAST_INSERT_ID()
into seqNo
from comm_perform_param t
where t.code = 'biz.settle.date';
end BRH_SEQ_GENERATOR;
begin
select t.current_value || appType || bizType || LAST_INSERT_ID()
into seqNo
from comm_perform_param t
where t.code = 'biz.settle.date';
end BRH_SEQ_GENERATOR;
select concat(t.current_value , appType , bizType , LAST_INSERT_ID()
into seqNo
from comm_perform_param t
where t.code = 'biz.settle.date';
end//
delimiter ;
create or replace pricedure BRH_SEQ_GENERATOR
(appType in VARCHAR,bizType in VARCHAR,seqno out varchar)
is
begin
select concat(t.current_value,t.apptype,t.bizType,t.Last_Insert_ID())
into seqno
from comm_perform_param t
end$$
delimiter;
create or replace procedure BRH_SEQ_GENERATOR
(appType in VARCHAR,bizType in VARCHAR,seqno out varchar)
is
begin
select concat(t.current_value,t.apptype,t.bizType,t.Last_Insert_ID())
into seqno
from comm_perform_param t;
end$$
delimiter;