declare v_devid char(18); v_eeid char(18); v_volume number; v_confnumber number; v_usecnumber number; v_oldconfnumber number; v_oldusecnumber number; v_outvolume number; v_convolume number; v_devvolume number; v_sysid char(18); begin v_devid:=:new.PARENTID; v_confnumber:=:new.CONFNUMBER; v_usecnumber:=:new.USECNUMBER; if inserting then v_eeid:=:new.EEID; select a.VOLUME into v_volume from DEVMODULE a,DEVRESOUSE b,MODUTYPE c where a.PARENTID=b.EEID and b.PARENTID=v_devid and a.MODUTYPEID=c.MODUTYPEID and c.MODUTYPENAME='整流模块' and rownum=1;这是我trigger的一部分,执行的时候抱select语句部分出错,但是我把select语句那出来单独执行的时候可以的,为什么会在trigger中就出错呢?
v_devid char(18);
v_eeid char(18);
v_volume number;
v_confnumber number;
v_usecnumber number;
v_oldconfnumber number;
v_oldusecnumber number;
v_outvolume number;
v_convolume number;
v_devvolume number;
v_sysid char(18);
begin
v_devid:=:new.PARENTID;
v_confnumber:=:new.CONFNUMBER;
v_usecnumber:=:new.USECNUMBER;
if inserting then
v_eeid:=:new.EEID;
select a.VOLUME into v_volume from DEVMODULE a,DEVRESOUSE b,MODUTYPE c
where a.PARENTID=b.EEID and b.PARENTID=v_devid and a.MODUTYPEID=c.MODUTYPEID and c.MODUTYPENAME='整流模块' and rownum=1;这是我trigger的一部分,执行的时候抱select语句部分出错,但是我把select语句那出来单独执行的时候可以的,为什么会在trigger中就出错呢?