Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: trigger help
Knut,
Thanks for responding. Orders_detail is a table joined on order_ID to orders_master and joined on material_ID to materials. Are you saying that I should be referencing that table with a select statement?
Mike
"Knut Talman" <knut.talman_at_mytoys.de> wrote in message
news:3CD94A35.FF5916C0_at_mytoys.de...
> Comments embeded.
>
> Mike Trozzo wrote:
> <snip>
> > SQL> create or replace trigger receive
> > 2 after insert or update on orders_master
> > 3 for each row
> > 4 when (old.received_date IS NULL
> > 5 and new.received_date IS NOT NULL)
> > 6 begin
> > 7 update materials set qty_onhand =
> > 8 (qty_onhand + orders_detail.qty_ordered)
>
> Where do you get orders_detail.qty_ordered from?
>
> > 9 where :new.order_ID = orders_detail.order_ID
>
> Same question: Where do you get orders_detail.order_ID from?
>
> > 10 and materials.material_ID = orders_detail.material_ID;
>
> Where do you select orders_detail.material_ID;?
>
> > 11 end receive;
> > 12 /
>
>
> Regards,
>
> Knut
Received on Wed May 08 2002 - 11:08:02 CDT