触发器编译出错
CREATE OR REPLACE TRIGGER x_ADS.TRG_GUID
BEFORE INSERT
ON x_ads.registuser
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
begin
select x_ADS.sqe_registuser.nextval into:new.GUID from dual;
end;
这个触发器哪里有错?
报错:
Compilation errors for TRIGGER X_ADS.TRG_GUID
Error: 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> << continue close current delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge pipe purge
Line: 14
Text: select x_ADS.sqe_registuser.nextval into:new.GUID from dual;