Is this a trigger bug?

[Quoted] [Quoted] Can select stamements that do not reutrn any rows be used in a trigger? [Quoted] The trigger does not seem to exceute or die if it encounters a select stmt. without any records?

.
.
.

if updating then
insert into temp_test values (' in updating');

   select distinct sr_active_dt
   into active_date
   from salesrep_hist
   where sr_id = :old.sr_id
   and to_char(sr_active_dt,'DDMMYY') = to_char(sysdate,'DDMMYY'); insert into temp_test values (' past select'); rem above stmt never gets exceuted!!!!!

   if (active_date is null) then Received on Mon Mar 03 1997 - 00:00:00 CET