Hi,
Need help with the below merge statement. I get the error ORA-30926: unable to get a stable set of rows in the source tables
===============================================================================================
MERGE INTO EC_EQPCONSTRAINT a
USING F5CIMPRODSTAGE.EC_EQPCONSTRAINT b
ON (a.EQPGRP_ID=b.EQPGRP_ID and a.AREA=b.AREA)
WHEN MATCHED THEN
UPDATE SET a.LotStart_Cleanroom ='C3,C5'
WHEN NOT MATCHED THEN
INSERT (EQPGRP_ID,EC_SNO,AREA,ENABLE,ACTION,PRIORITY,RECPGRP_ID,DEVGRP_ID,PROCGRP_ID,STGGRP_ID,CUSTGRP_ID,LOTGRP_ID,LOTTYPE,CHAMBERNO,MAX_LOTS_PER_DAY,REASON,CREATION_DATE,CREATION_USER_ID,MODIFIED_DATE,MODIFIED_USER_ID,TOTAL_RUNCOUNT,MTD_RUNCOUNT,UPD_RUNLOTS,LotStart_Cleanroom)
VALUES ( b.EQPGRP_ID,(select max(EC_SNO)+1 from EC_EQPCONSTRAINT),b.AREA,b.ENABLE,b.ACTION,b.PRIORITY,b.RECPGRP_ID,b.DEVGRP_ID,b.PROCGRP_ID,b.STGGRP_ID,b.CUSTGRP_ID,b.LOTGRP_ID,b.LOTTYPE,b.CHAMBERNO,b.MAX_LOTS_PER_DAY,b.REASON,b.CREATION_DATE,b.CREATION_USER_ID,b.MODIFIED_DATE,b.MODIFIED_USER_ID,b.TOTAL_RUNCOUNT,b.MTD_RUNCOUNT,b.UPD_RUNLOTS,'C5');
What would be the right statement to resolve this error?