Re: enabling triggers

On Thu, 30 Nov 2000 23:38:51 -0800, Greg DeMent <dementg_at_usa.net> wrote:

>Thanks to everybody for clearing that up. It's working now, almost. I'm
>getting a warning message though, here's what I'm entering:
>
>LOGIT table is defined as:
>key char(20)
>log_comment char(20)
>
>member.ssn is a char(9)
>
>SQL> create trigger tr_log
> 2 after insert on member
> 3 for each row
> 4 insert into logit values(new.ssn, 'INSERTED');
> 5 /

You should use and END; or END trigger tr_log; for line 5 and the forward slash on line 6. Also, make use of the SHOW ERRORS command.

Brian Received on Fri Dec 01 2000 - 08:25:26 CST