Re: trouble on trigger

From: Setiawan Wijaya <swsan_at_flashmail.com>
Date: Fri, 15 Dec 2000 10:28:02 +0700
Message-ID: <eys_5.11672$K6.86127@news>

Sorry, I only got this message from oracle

Warning: Trigger created with compilation errors.

Regards,
Setiawan

John Alexander <jalexander_at_summitsoftwaredesign.com> wrote in message news:NX8_5.134129$vc3.26859836_at_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 - 21:28:02 CST