Error during merge operation: 'NoneType' object has no attribute 'collect'

GS_S
New Contributor III

Why does merge.collect() not return results in access mode: SINGLE_USER, but it does in USER_ISOLATION? I need to log the affected rows (inserted and updated) and can’t find a simple way to get this data in SINGLE_USER mode. Is there a solution or an alternative method to retrieve this information?

#merge

#SINGLE_USER

#USER_ISOLATION