Re: Compilation errors in TRIGGER

kev 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;
> /
>

doesn't PL/SQL use and ':=' operator for assignments.

>
> 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 - 08:27:31 CDT