CREATE OR REPLACE PROCEDURE FUN_GET_MCT_NAME(p_i_mct_code OUT VARCHAR) IS
v_result VARCHAR(100);BEGIN
v_result = '-'; SELECT t.MCT_NAME INTO v_result
FROM B_IMP_MCT_CFG t
WHERE TRIM(t.MCT_CODE)=TRIM(p_i_mct_code);
p_i_mct_code=v_result;END;报错说是必须声明标识符“FUN_GET_MCT_NAME”
v_result VARCHAR(100);BEGIN
v_result = '-'; SELECT t.MCT_NAME INTO v_result
FROM B_IMP_MCT_CFG t
WHERE TRIM(t.MCT_CODE)=TRIM(p_i_mct_code);
p_i_mct_code=v_result;END;报错说是必须声明标识符“FUN_GET_MCT_NAME”
CREATE OR REPLACE PROCEDURE FUN_GET_MCT_NAME(p_i_mct_code OUT VARCHAR) IS
v_result VARCHAR(100);
BEGIN
v_result := '-';
SELECT t.MCT_NAME INTO v_result
FROM B_IMP_MCT_CFG t
WHERE TRIM(t.MCT_CODE)=TRIM(p_i_mct_code);
p_i_mct_code:=v_result;
END FUN_GET_MCT_NAME;