Oracle的stored procedure,SUCCESS由外面傳過來
CREATE PROCEDURE PROFCAL(xCOMPID IN VARCHAR2,CURDATE IN VARCHAR2,SUCCESS OUT VARCHAR2)
IS
BEGIN
--Other Codes
COMMIT;
SUCCESS:='Y';--'Y'表示算成功
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
SUCCESS:='N';--'N'表示失敗
END PROFCAL;
CREATE PROCEDURE PROFCAL(xCOMPID IN VARCHAR2,CURDATE IN VARCHAR2,SUCCESS OUT VARCHAR2)
IS
BEGIN
--Other Codes
COMMIT;
SUCCESS:='Y';--'Y'表示算成功
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
SUCCESS:='N';--'N'表示失敗
END PROFCAL;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货