修改为如下试试:
CREATE OR REPLACE TRIGGER insertliu1
BEFORE insert on liu1
for each row
declare
-- local variables here v_name varchar2(10);
begin
begin
select name
into v_name
from liu
where id=:new.countid;
exception
when no_data_found then
v_name:=null;
when others then
v_name:=null;
end;
:new.name:=v_name;
end insertliu1;
CREATE OR REPLACE TRIGGER insertliu1
BEFORE insert on liu1
for each row
declare
-- local variables here v_name varchar2(10);
begin
begin
select name
into v_name
from liu
where id=:new.countid;
exception
when no_data_found then
v_name:=null;
when others then
v_name:=null;
end;
:new.name:=v_name;
end insertliu1;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货