trouble on trigger
From: Setiawan Wijaya <swsan_at_flashmail.com>
Date: Thu, 14 Dec 2000 17:52:22 +0700
Message-ID: <2Zd_5.11642$K6.85838_at_news>
Date: Thu, 14 Dec 2000 17:52:22 +0700
Message-ID: <2Zd_5.11642$K6.85838_at_news>
[Quoted] [Quoted] I have a trigger, when I'm running the update query it's fine but when i'm put into trigger it's error
CREATE OR REPLACE TRIGGER EXCHG_RATE
AFTER UPDATE ON CURRENCY
FOR EACH ROW
BEGIN
UPDATE PRICE
SET SELL_PRICE =
CASE WHEN EXTRA_COST_CURRENCY = 'IDR' THEN
ROUND(((25* COST_PRICE) + EXTRA_COST_PRICE) *
(1+(MARGIN_PERCENTAGE/100)),-3)
ELSE
ROUND(((25* COST_PRICE) + (25* EXTRA_COST_PRICE)) *
(1+(MARGIN_PERCENTAGE/100)),-3)
END
WHERE COST_PRICE_CURRENCY = 'USD';
END;
/
[Quoted] [Quoted] [Quoted] Please help me find the error...
Thanks,
Setiawan Wijaya
Received on Thu Dec 14 2000 - 11:52:22 CET