Re: Oracle 8i - Triggers
From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 12 Mar 2003 13:48:47 -0800
Message-ID: <1b061893.0303121348.3bce9f56_at_posting.google.com>
Date: 12 Mar 2003 13:48:47 -0800
Message-ID: <1b061893.0303121348.3bce9f56_at_posting.google.com>
That compiled for me (but I didn't test with data):
CREATE OR REPLACE TRIGGER dec_stck
BEFORE INSERT OR UPDATE ON custorder
FOR EACH ROW
declare
my_custord_qty pls_integer;
my_custord_stck_id pls_integer;
begin
my_custord_qty := :new.custorder_qty;
my_custord_stck_id := :new.custord_stck_id;
UPDATE stock SET total_in_stock = (total_in_stock - my_custord_qty)
where stock_id = my_custord_stck_id;
end;
/
Daniel Received on Wed Mar 12 2003 - 22:48:47 CET