Re: discovering PL/SQL and triggers

From: Keith Jamieson <pdkj02_at_email.mot.com>
Date: Thu, 04 Feb 1999 10:17:59 +0000
Message-ID: <36B973D7.8A0DB407@email.mot.com>

Try the following:
Create or Replace Trigger before delete on table1
For Each Row
Declare
date_deleted DATE;
Begin
Insert into table_name(column_name,date_column)
values(:old.column_name,date_deleted)
 
End

NB: I put the date in, as I know it can be very useful
Serge LUCAS wrote:

I have a problem while trying to create a trigger. Can somebody help me:

I have to table t1 & t2:
>       create table t1(X number);
>       create table t2(X number);

and want to create a trigger so that, when I delete a row from t1, it is
automatically copied on t2:

>       create trigger tr after delete on t1 for each row
>       begin
>       insert into t2 values(OLD.X);
>       end;
I obtain the following message from Oracle:
        Warning: Trigger created with compilation errors.

Can somebody tell me what is the error, or if there is a debug option to
have complementary information on the error?

Thanks !

  Received on Thu Feb 04 1999 - 04:17:59 CST