oracle触发器错误:PLS-00103:出现符号""在需要下列之一时:createorreplacetriggertribifertranslatebeforeinsertontranslateforeachrowbeginselectseqtranslate.nextvalinto:new.TranslateNOfromdual;end;TRIGGERSCOTT.TRI

Question

oracle触发器错误:PLS-00103: 出现符号 ""在需要下列之一时:create or replace trigger tri_bifer_translate before insert on translate for each row begin select seq_translate.nextval into:new.TranslateNO from dual; end; TRIGGER SCOTT.TRI_BIFER_TRANSLATE 编译错误 错误：PLS-00103: 出现符号 ""在需要下列之一时： begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe 行：6 文本： select seq_translate.nextval into:new.TranslateNO from dual;

Answer 1

好像 代码里面， 好多的空格，是全角字符的空格. 换成半角的看看?