Re: Is this a trigger bug?

amit srivastava wrote:
>
> Can select stamements that do not reutrn any rows be used in a trigger?
> The trigger does not seem to exceute or die if it encounters
> a select stmt. without any records?

  It was becase NO_DATA_FOUND exception is raised and you do not handle it.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.