Re: discovering PL/SQL and triggers

Mark Styles wrote:
> I recommend using 'create or replace' instead of just 'create'
> the variable should be :OLD.X not OLD.X
> When you get this error, you can do 'show errors' in SQL*Plus to see
> more details.

I wrote the following:

Create or Replace Trigger tr before delete on t1 For Each Row
begin
Insert into t2
values(:old.X);
end;
/

and it RUNS !

Thanks you ALL!
--
Serge LUCAS
STERIA ATM/Eurocontrol
BS-012
Tel 01 69 88 74 15
Fax 01 69 88 73 33
Mel lua_at_eurocontrol.fr Received on Thu Feb 04 1999 - 08:30:52 CST