Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: trouble on trigger

Re: trouble on trigger

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Thu, 14 Dec 2000 19:11:41 GMT
Message-ID: <NX8_5.134129$vc3.26859836@typhoon.tampabay.rr.com>

What's the error message?
Setiawan Wijaya <swsan_at_flashmail.com> wrote in message news:2Zd_5.11642$K6.85838_at_news...
> 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;
> /
>
>
>
> Please help me find the error...
>
> Thanks,
> Setiawan Wijaya
>
>
>
>
Received on Thu Dec 14 2000 - 13:11:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US