Re: Compilation errors in TRIGGER

try this

create trigger trig1 before insert on webtab1 for each row
BEGIN
    select seq1.nextval into :new.id from dual; END;
/

kev wrote in message <37A0530E.32CDD69B_at_fast.no>...
>Hi,
>
>I'm trying to create a trigger for autonumbering. I get this error
>message though:
>
>MGR-00072: Warning: TRIGGER TRIG1 created with compilation errors.
>
>Can I find out what these compilation errors are?
>
>Or even better, can you tell me what's wrong with this code (I'm using
>svrmgrl) ? :-)
>
>create trigger trig1 before insert on webtab1
>for each row
>BEGIN
>:new.id = seq1.nextval;
>END;
>/
>
>seq1 is a sequence. The table webtab1 just has 3 columns: id number(4),
>lname varchar2(10), fname varchar2(10)
>
>Thanks in advance,
>
>- Kev
>
Received on Fri Jul 30 1999 - 03:04:20 CDT