Re: Newbie Trigger Syntax

declare

   skill_rec c.skill_number%type;

begin

/* Implicit cursor; Throws NO_DATA_FOUND when

    employee does not posess skill. . . . */

 select c.skill_number into skill_rec    from c
 where c.employee_number = :old.employee_number

    and c.skill_number = 1
    and c.rownum <=1; --Important: one row at most!

exception

    when NO_DATA_FOUND

         then raise_application_error(-20225, "Unqualified");

end; Received on Fri Nov 30 2001 - 17:14:50 CST