ok,代码是:
create or replace trigger aaa
before insert on mcc_ctrlcmd
for each row
declare
-- local variables herev varchar2(10);
--declare
v varchar2(20);
begin
v :=substr(mcc_ctrlcmd.mac,length(mcc_ctrlcmd.mac)-11,11);
update minimis.ratedesc set userate =userate-1
where ratedesc.CARID =(
select xj_vehicle_obj.carnumber from minimis.xj_vehicle_obj, minimis.xj_serviceunit, minimis.xj_simcode_obj
where xj_vehicle_obj.id = xj_serviceunit.vehicleid
and xj_simcode_obj.id = xj_serviceunit.simcodeid
and xj_simcode_obj.persimcode=v
-- substr(mcc_ctrlcmd.mac,length(mcc_ctrlcmd.mac)-11,11)
)
and (minimis.ratedesc.ratetime =(select max(minimis.ratedesc.ratetime)
from minimis.ratedesc));end aaa;
create or replace trigger aaa
before insert on mcc_ctrlcmd
for each row
declare
-- local variables herev varchar2(10);
--declare
v varchar2(20);
begin
v :=substr(mcc_ctrlcmd.mac,length(mcc_ctrlcmd.mac)-11,11);
update minimis.ratedesc set userate =userate-1
where ratedesc.CARID =(
select xj_vehicle_obj.carnumber from minimis.xj_vehicle_obj, minimis.xj_serviceunit, minimis.xj_simcode_obj
where xj_vehicle_obj.id = xj_serviceunit.vehicleid
and xj_simcode_obj.id = xj_serviceunit.simcodeid
and xj_simcode_obj.persimcode=v
-- substr(mcc_ctrlcmd.mac,length(mcc_ctrlcmd.mac)-11,11)
)
and (minimis.ratedesc.ratetime =(select max(minimis.ratedesc.ratetime)
from minimis.ratedesc));end aaa;
不能在行级触发器引用自身表