create or replace trigger test
after update
on t_customer02
for each row
begin
update t_customer03 set NAME=:new.NAME,SEX=:new.SEX where ID=:old.ID;
end;
出现 “索引中丢失in 或 out参数::1”的错误,我想问下是哪里有问题
...全文
362710打赏收藏
索引中丢失in 或 out参数
customer02 和 customer03 中姓名,性别等一些字段是完全一样的,我想在customer02表发生更改时,自动把customer02表的新值更新到customer03表中, create or replace trigger test after update on t_customer02 for each row begin update t_customer03 set NAME=:new.NAME,SEX=:new.SEX where ID=:old.ID; end;
缺少了declare关键字
create or replace trigger test
after update on t_customer2
for each row
declare
begin
update t_customer3 set name=:new.name,sex=:new.sex where id=:old.id;
end test;