Question

PL/SQL: ORA-00933: SQL 命令未正确结束 两个错误怎么都不知道为什么..菜鸟求助

create trigger updatec after update or delete of balance on account2
for each row
begin
if inserting then
update customer2 set sum_balance =:new.balance where customer_name=:new.customer_name;
else
update customer2 set sum_balance =null where customer_name =:new .customer_name;
end if;

end ;

[Error] PLS-00103 (8: 15): PLS-00103: 出现符号 "end-of-file"在需要下列之一时：
( begin case
declare else elsif end exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimi

( begin case
declare else elsif end exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimi

Answer 1

create trigger updatec after update or delete of balance on account2
for each row
begin
if inserting then
begin
update customer2 set sum_balance =:new.balance where customer_name=:new.customer_name;
end;
else
begin
update customer2 set sum_balance =null where customer_name =:new .customer_name;
end;
end if;

end ;

Answer 2

LZ贴的这个没有错，估计你实际的代码多了一个逗号吧？