discovering PL/SQL and triggers

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:14:10 CST