ORA-12838: cannot read/modify an object after modifying it in parallel
559037Sep 19 2007 — edited Sep 25 2007I am getting the above error when i hit this part in my load ....
can somebody suggest me why it could be in this case ?
MERGE INTO PART1 H
USING (SELECT PA1, PART1, CON1, GEO1, COUN1, KIT1 FROM W1 ) WH ON
(H.PART1=WH.PART1) --on PK darshan 01-03-2006
WHEN MATCHED THEN
UPDATE SET H.CON1 =WH.CON1, H.GEO1 = FN_GETGEOCODE ( WH.GEO1 ), H.COUN1 =WH.COUN1, H.KIT1 =WH.KIT1, H.DT1 =TO_NUMBER(TO_CHAR(FN_GETGMTDATE(SYSDATE),'YYYYMMDD')), H.DT_LAST1 = FN_GETGMTDATE(SYSDATE)
WHEN NOT MATCHED THEN
INSERT (H.PART1, H.PART2, H.CON1, H.GEO1, H.COUN1, H.KITD1, H.DT1, H.DT_1, H.DT_LAST_1)
VALUES(CASE FN_MERGE_COUNTER(gpi_inserting)
WHEN 0 THEN WH.PART1 END, WH.PARTN1, WH.CON1, FN_GETGEOCODE ( WH.GEO1), WH.COUNT1, WH.KIT1,
TO_NUMBER(TO_CHAR(FN_GETGMTDATE(SYSDATE),'YYYYMMDD')), PKG_COMMONACTIVITIES.FN_GETGMTDATE(SYSDATE), PKG_COMMONACTIVITIES.FN_GETGMTDATE(SYSDATE)
);