读书人

ORACLE存储过程出错各位

发布时间: 2013-03-26 21:09:08 作者: rapoo

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;

读书人网 >oracle

热点推荐