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_GUIDError: 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;
begin select x_ADS.sqe_registuser.nextval into:new.GUID from dual; end;
这个触发器哪里有错?报错:
Compilation errors for TRIGGER X_ADS.TRG_GUIDError: 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;
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;--into和:new.GUID少了空格
end;
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;
楼主试试这个
可能你中间某些空格的格式不对 系统无法识别
把空格都删掉就好了
跟用户有没有关系?
我用的是另外一个用户 dba的。
表和序列都是x_ads用户的。