请教触发器问题
ORIGINAL_QUANTITY 表里有ORIGINAL_QUANTITY 字段.
我想更新表oa_goodsinfo,让它里面的realnum和stocknum的值都等于ORIGINAL_QUANTITY
条件是这两个表里面goodsid和MATERIAL_ID相等的纪录.
我写的这个触发器可以,但是set接连写两个就报错
请问怎么实现.CREATE OR REPLACE TRIGGER OA_STOCK_QUANTITY_TR
AFTER INSERT ON OA_ORIGINAL_STORE
FOR EACH ROW
BEGIN
UPDATE oa_goodsinfo
SET realnum = (select ORIGINAL_QUANTITY
from OA_ORIGINAL_STORE
where goodsid = OA_ORIGINAL_STORE.MATERIAL_ID);
realnum = (select ORIGINAL_QUANTITY
from OA_ORIGINAL_STORE
where goodsid = OA_ORIGINAL_STORE.MATERIAL_ID);
EXCEPTION WHEN OTHERS THEN
RAISE;
END OA_STOCK_QUANTITY_TR;