Question

在oracle中执行sql语句如下，发现警告：创建的触发器带有编译错误，求指教！！！

create sequence "Sequence_APP"
increment by 1
start with 1
/
create table APP (
AID NUMBER(20) not null,
AKEY VARCHAR2(100) not null,
AREMARK VARCHAR2(1000),
constraint PK_APP primary key (AID)
)
/
create unique index "Index_APP" on APP (
AKEY ASC
)
/
create trigger "tib_app" before insert
on APP for each row
declare
integrity_error exception;
errno integer;
errmsg char(200);
dummy integer;
found boolean;
begin
-- Column "AID" uses sequence Sequence_APP
select Sequence_APP.NEXTVAL INTO :new.AID from dual;
-- Errors handling
exception
when integrity_error then
raise_application_error(errno, errmsg);
end;
/

Answer 1

办法一:把序列和触发器名字中的引号去掉.
办法二:触发器中,select "Sequence_APP".NEXTVAL INTO :new.AID from dual;

Answer 2

貌似问题出在 found boolean;上。记得Oracle可以使用布尔类型数据，但不能定义布尔类型变量。