Re: triggers
From: Michael Abbey <msabbey_at_magi.com>
Date: 1996/02/02
Message-ID: <4es1ff$jmh_at_news.magi.com>#1/1
Date: 1996/02/02
Message-ID: <4es1ff$jmh_at_news.magi.com>#1/1
Heather Dyson <dyson_at_template.com> wrote:
>I need to create a trigger in the database but
>it doesn't seem to be accepting it. I am using
>sqlplus. Can anyone tell me where I am going
>wrong?
>CREATE TRIGGER update_trig
>BEFORE
>UPDATE
>ON table
>BEGIN
> INSERT INTO table2
> VALUES(new.field, 1);
>END update_trig;
/
You need the slash in the previous line to terminate the PL/SQL block.
Unless there are any other syntax errors, this will pass the PL/SQL to
Oracle for compilation.
Michael
>Sqlplus just waits for more input.
>Thanks,
>Heather
Received on Fri Feb 02 1996 - 00:00:00 CET