After Insert/Update trigger question
From: Ken Halsted <kenman_at_mail.snider.net>
Date: 2000/02/16
Message-ID: <sam7f4ue2pd168_at_corp.supernews.com>#1/1
CREATE OR REPLACE TRIGGER T_CUSTOMERS_AIUR AFTER INSERT OR UPDATE ON AR_CUSTOMERS
FOR EACH ROW
BEGIN
UPDATE_CEDR_CUSTS(:NEW.CUSTOMER_NUMBER); END;
Date: 2000/02/16
Message-ID: <sam7f4ue2pd168_at_corp.supernews.com>#1/1
[Quoted] [Quoted] I have this trigger on table: AR_CUSTOMERS:
CREATE OR REPLACE TRIGGER T_CUSTOMERS_AIUR AFTER INSERT OR UPDATE ON AR_CUSTOMERS
FOR EACH ROW
BEGIN
UPDATE_CEDR_CUSTS(:NEW.CUSTOMER_NUMBER); END;
UPDATE_CEDR_CUSTS simply reads the SAME table based on the customer number and updates another table in our database with some of the info.
I keep getting an error when I update or insert a record from the form based [Quoted] on AR_CUSTOMERS but if I run the procedure stand-alone, it works fine. Any suggestions?
[Quoted] Thanks for any help,
Ken. Received on Wed Feb 16 2000 - 00:00:00 CET