trigger编译没法通过

trigger编译无法通过
点击右边红色标题查看本文完整版：trigger编译无法通过

trigger编译无法通过。代码如下：

CREATE OR REPLACE TRIGGER biud_sp_info
BEFORE INSERT OR UPDATE ON sp_info
FOR EACH ROW
?
BEGIN
? IF NEW.sp_code IN (SELECT sp_code FROM sp_info) THEN
? Error(-200001, ‘You must make sure THE sp_code DISTINCT.’);


? END IF;
?
?
END;

------解决方法--------------------
‘You must make sure THE sp_code DISTINCT.’

是中文字符。改成：

'You must make sure THE sp_code DISTINCT. '

即可
------解决方法--------------------
NEW.sp_code前漏了冒号“:”