AFTER INSERT TRIGGER FOR :NEW TYPE
885913May 17 2012 — edited May 21 2012Hi experts,
I have an issue that after shipping the sales order item instance is created, for both the tables (oe_order_headers_all, csi_item_instances) created dff's in sale order lines level for dff i give one string my task is when ever item instance is created with sales order that dff value is printed here also for that i write the trigger
TRIGGER item_instance
after insert on CSI_ITEM_INSTANCES
FOR EACH ROW
DECLARE
L_ATTRIBUTE3 VARCHAR2(100);
CURSOR ATTR (C_LINE_ID NUMBER)IS
SELECT ATTRIBUTE16 FROM OE_ORDER_LINES_ALL WHERE LINE_ID=C_LINE_ID AND ATTRIBUTE16 IS NOT NULL;
begin
FOR I IN ATTR(:OLD.LAST_OE_ORDER_LINE_ID)LOOP
L_ATTRIBUTE3:= I.attribute16;
END LOOP;
:NEW.ATTRIBUTE3:=L_ATTRIBUTE3;
end;
for this i getting the error
"*Line: 1 Column: 9 Error: ORA-04084: cannot change NEW values for this trigger type*"
can anybody pls help me in this issue.
thanks,
christ
Edited by: 882910 on May 17, 2012 2:48 AM