oracel触发器有关问题,值之间的传递。 急

oracel触发器问题,值之间的传递。在线等.... 急~！~！~
create or replace trigger trigger_Eis_role
after insert on user
for each row DECLARE organId char(32);
select organ_id into organId from emp_employee where user_id = username;--user_id 是唯一的 后面我要用到organId， 这种方式能不能将查询出来的organ_id的值传递给organId如果查询出来是空的时候会报错?
在线等.... 急



[解决办法]
先判断
declare 
..
cou int :=0;
...
select count(1) into cou from emp_employee where user_id = username;
if cou<>0
select organ_id into organId from emp_employee where user_id = username;
end if;

[解决办法]
OR

SQL code

create or replace trigger trigger_Eis_roleafter insert on userfor each row DECLARE organId char(32);select organ_id into organId from emp_employee where user_id = username;EXCEPTION WHEN No_Data_Found THEN    organId:='';