db2ä¸ç±»ä¼¼oracleçå¼å¸¸æè·åæ³ï¼
举ä¾å¦ä¸ï¼
CREATE PROCEDURE OUT_LANGUAGE (...,OUT returnCode INTEGER, OUT returnMsg CHAR(32))
-- returnCode è¿åæ§è¡ä¸ççé误代ç
-- returnMsg è¿åæ§è¡ä¸ççé误æè¿°
SPECIFIC SQL_OUT_LANGUAGE
LANGUAGE SQL
BEGIN
DECLARE SQLCODE INTEGER DEFAULT 0;
DECLARE SQLSTATE CHAR(5) DEFAULT ´00000´;
DECLARE errorLabel CHAR(32) DEFAULT ´´;
......
-- in case of no data found
DECLARE CONTINUE HANDLER FOR NOT FOUND
BEGIN
SET returnCode = SQLCODE;
-- ä¹å¯ä»¥è®¾ç½®ä¸º SET returnCode = 0; å 为è¿ä¸ªDECLAREæ¯ä¸ºäºå¿½ç¥NOT FOUNDçæ§è¡ç»æ
END;
-- in case of SQL error
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SET returnCode = SQLCODE;
SET returnMsg = errorLabel;
END;
温馨提示:答案为网友推荐,仅供参考