Re: Compilation errors in TRIGGER

In the Trigger use this statement

  select seq1.nextval into :new.id from dual;

It should work.

kev <kevin.porter_at_fast.no> wrote:
>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 Thu Jul 29 1999 - 09:38:31 CDT