Database Trigger on OE_ORDER_LINES_ALL
388895Apr 1 2003 — edited Apr 15 2003Hi,
I am trying to create a trigger on this table to update
attribute11 with a function call.
CREATE OR REPLACE TRIGGER SD_COST_ATTR
AFTER INSERT OR UPDATE ON oe_order_lines_all
FOR EACH ROW
Begin
:new.attribute := functioncall(xxx);
end;
1) Will this update the cuurent record that is inserting or update???
2) If not, do I need to save the line_id value for an update clause?
3) Since this is an insert or update on the same table, will it be A Mutating trigger?
Thx