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前漏了冒号“:”