CREATE TABLE A1 AS (SELECT '01' A,'AA' B,'BB' C FROM DUAL UNION ALL SELECT '02' A,'CC' B,'DD' C FROM DUAL UNION ALL SELECT '03' A,'EE' B,'FF' C FROM DUAL ) CREATE OR REPLACE PROCEDURE PPPP (P_A VARCHAR2, P_B OUT VARCHAR2, P_C OUT VARCHAR2) IS BEGIN IF NVL(P_A,' ') IN (SELECT A FROM A1) THEN SELECT B,C INTO P_B,P_C FROM A1 WHERE A=P_A; ELSE P_B:='00'; P_C:='00'; END IF; EXCEPTION WHEN OTHERS THEN NULL; END; 僅供參考!
UNION ALL
SELECT '02' A,'CC' B,'DD' C FROM DUAL
UNION ALL
SELECT '03' A,'EE' B,'FF' C FROM DUAL
)
CREATE OR REPLACE PROCEDURE PPPP (P_A VARCHAR2,
P_B OUT VARCHAR2,
P_C OUT VARCHAR2)
IS
BEGIN
IF NVL(P_A,' ') IN (SELECT A FROM A1) THEN
SELECT B,C INTO P_B,P_C FROM A1 WHERE A=P_A;
ELSE
P_B:='00';
P_C:='00';
END IF;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
僅供參考!