这是报错信息
这是新增触发器的sql
在切换到超级管理员后,查看当前用户的权限,对照老版数据库,在另一个备份账户下创建了相关的表,并给当前用户添加上相关的操作权限。再切换回当前用户,尝试 “检查-编译”,返回OK,不再报红叹号。执行sql,OK,成功触发相关的触发器。
希望能对你有用!!!
create or replace trigger "CompoundDeleteTrigger_sys_city"
for delete on SYS_CITY compound trigger
// Declaration
// Body
before statement is
begin
NULL;
end before statement;
before each row is
begin
NULL;
end before each row;
after each row is
begin
NULL;
end after each row;
after statement is
begin
NULL;
end after statement;
END
/
create or replace trigger "CompoundInsertTrigger_sys_city"
for insert on SYS_CITY compound trigger
// Declaration
// Body
before statement is
begin
NULL;
end before statement;
before each row is
begin
NULL;
end before each row;
after each row is
begin
NULL;
end after each row;
after statement is
begin
NULL;
end after statement;
END
/
create or replace trigger "CompoundUpdateTrigger_sys_city"
for update on SYS_CITY compound trigger
// Declaration
// Body
before statement is
begin
NULL;
end before statement;
before each row is
begin
NULL;
end before each row;
after each row is
begin
NULL;
end after each row;
after statement is
begin
NULL;
end after statement;
END
/
create trigger "tib_sys_city" before insert
on SYS_CITY for each row
declare
integrity_error exception;
errno integer;
errmsg char(200);
dummy integer;
found boolean;
begin
-- Column "ID" uses sequence SQ_SYS_CITY
select SQ_SYS_CITY.NEXTVAL INTO :new.ID from dual;
-- Errors handling
exception
when integrity_error then
raise_application_error(errno, errmsg);
end;
/