一、ORACLE
DECLARE
errCodevarchar2(20);
errMsgVARCHAR2(100);
BEGIN
HIS_TEST.PRC_RREG('184151','0002173828',errCode,errMsg);
dbms_output.put_line(errCode);
dbms_output.put_line(errMsg);
end;
二、SQL Server(Navicat中文版支持,百度云上的就是中文版)
DECLARE
@MSGVARCHAR(10),
@HisTradeIdvarchar(50)
begin
execsp_appoint_reg '1402768','2015-06-15',
'1','2015-06-15','12','1','1010400','00048','68855346','朱峰峰','412826198902148511',
'18758004899','1','26','123',@MSG out,@HisTradeId out;
print @MSG;(或select @MSG;)
print @HisTradeId;(或select @HisTradeId;)
end;
三、MySQL(变量不用声明,直接用)
call PRO_REPORTSTATE('reportNo','1',null,'cardNo','18758004899','checkItem',SYSDATE(),@errCode,@errMsg);
SELECT @errCode;
SELECT @errMsg;