Re: discovering PL/SQL and triggers

Keith Jamieson wrote:
>
> 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

I have done the following:

SQL> Create or Replace Trigger tr before delete on t1   2 For Each Row
  3 --Declare
  4 --date_deleted DATE;
  5 Begin
  6 Insert into t2(X)
  7 values(:old.X)
  8 End;
  9 /
And the result is:
<<Warning: Trigger created with compilation errors.>>

so, it doesnt run this way... Received on Thu Feb 04 1999 - 06:40:46 CST