Re: Trigger, help
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 27 May 2002 04:47:30 -0700
Message-ID: <a20d28ee.0205270347.5b244c7_at_posting.google.com>
Date: 27 May 2002 04:47:30 -0700
Message-ID: <a20d28ee.0205270347.5b244c7_at_posting.google.com>
Quoc Cuong Nguyen <quonguye_at_numbat.cs.rmit.edu.au> wrote in message news:<3cf1bdf4_at_itsawnews.its.rmit.edu.au>...
> I've used the following command to create a trigger:
> CREATE TRIGGER trigger_name
> BEFORE INSERT ON table_name
> BEGIN
> rem Doing something
> END;
> The system informed that:
> Trigger created with compilation error.
>
> What is wrong with that ?
> Thank you,
'empty' pl/sql blocks without executable code are not allowed. You need to include at least the
null;
statement.
Hth
Sybrand Bakker
Senior Oracle DBA
Received on Mon May 27 2002 - 13:47:30 CEST