Re: PL/SQL Triggers

rni_at_slv.dk (Roy Nielsen) wrote:

>create or replace trigger mytrigger
>before insert on wintcc.alarm
>
>begin
> select seqmyname.nextval
> into :new.alarmid
> from dual;
>end;
>
>but this doesn't work, my eror msg is that

I think you must add a "for each row" clause to make the trigger fire for a row that gets inserted.

HTH

--
Ludo Joris
RUCA - University of Antwerp, Belgium
lujo_at_ruca.ua.ac.be