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

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

Re: trouble on trigger

From: <sybrandb_at_my-deja.com>
Date: Fri, 15 Dec 2000 12:30:20 GMT
Message-ID: <91d2st$nt8$1@nnrp1.deja.com>

In article <eys_5.11672$K6.86127_at_news>,
  "Setiawan Wijaya" <swsan_at_flashmail.com> wrote:
> 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
> > >
> > >
> > >
> > >
> >
> >
>
>

Tip : after this message
run
select * from user_errors where name = '<your trigger name>' or
show errors

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/
Received on Fri Dec 15 2000 - 06:30:20 CST

Original text of this message

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