PLS-00103:Encountered the symbol "" when expecting one of the following:pragma when
问题描述:
PLS-00103:Encountered the symbol "" when expecting one of the following:pragma when
这是部分存储过程P1脚本,尾部
END LOOP;
CLOSE v_Result;
EXCEPTION (报错位置)
WHEN ERR_INPUT_PARA THEN
o_Code := 0;
o_Message := v_Message;
WHEN ERR_MID_PARA THEN
o_Code := 0;
o_Message := 'Message has already sended today!';
WHEN ERR_NULL_DATA THEN
o_Code := 0;
o_Message := 'No strategy unit matched!';
WHEN ERR_TIME_PARA THEN
o_Code := 0;
o_Message := 'Send time is not matched!';
END P1;
不明白这是什么错误
答
检查一下,
EXCEPTION 和 WHEN 之间有没有 不可见的字符,比如中文全角的空格