ORACLE存储过程出错,求助各位
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”
------解决方案-------------------- ORALCE 赋值v_result
:= '-';
------解决方案--------------------
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;