Re: HELP with TRIGGER

>drop trigger a2Nulify;
>
>drop table a4;
>drop table a3;
>
>create table a3 (
> customer_number number,
> customer_address char(30),
> PRIMARY KEY (customer_number))
>STORAGE (INITIAL 10K NEXT 10K)
>;
>
>create table a4 (
> Account_Number number PRIMARY KEY,
> customer_number number NULL REFERENCES a3, /* Same as ON
 DELETE RESTRICT
>ED */
> Amount number,
> Prefered_Dr char(20) UNIQUE)
>STORAGE (INITIAL 10K NEXT 10K)
>;
>
>
>insert into a3 values (001, 'Sydney');
>insert into a3 values (002, 'Melbourne');
>insert into a3 values (003, 'Canberra');
>insert into a3 values (004, 'Queensland');
>
>insert into a4 values (1000, 001, 390, 'Martin');
>insert into a4 values (1010, 002, 70, 'Robert');
>insert into a4 values (1021, 004, 34, 'David');
>insert into a4 values (1030, 002, 304, 'Tomas');
>insert into a4 values (1041, 003, 134, 'Allan');
>
>
>CREATE TRIGGER a2Nulify
>BEFORE DELETE ON OPS$NEURAL.a3
>FOR EACH ROW
>BEGIN
> UPDATE OPS$NEURAL.a4
> set OPS$NEURAL.a4.CUSTOMER_NUMBER = NULL
> where a3.customer_number = a4.customer_number;
>END;
>/
>==========================ORACLE

 ERROR=========================================

I think in your trigger since you are writing a trigger on a3 you cannot simply use where a3.customer_number. Try to use corelation names as :old.customer_number.

Hope this solves your problem.

Fm : Upinder Aggarwal Received on Thu Aug 24 1995 - 00:00:00 CEST