when i am inserting new item its working
but when im updating item its not working
can any one help me?
IF I_FBP_CHANGED = 'C' AND I_INITIAL_CUST_LOAD IS NOT NULL THEN
insert into ABC
(restortn_step_id, evnt_id ,cust_acc_no ,house_no ,street_name ,cust_name
, MODIFED_TIMESTAMP,MODIFED_BY )
(select I_STEP_ID as step_id ,
I_EVNT as evnt_id, a.acc_no,a.house_no, a.street_name
,a.cust_name
, sysdate , MODIFIED_BY from ABC a
where a.restortn_step_id = I_INITIAL_CUST_LOAD);
i need to update item using this query how?