DSXchange

hi i am getting this error while i am trying to insert records in to Oracle Enterprise usinfg auto generated insert then update.

Unable to use a record for update due to ORA-00060: deadlock detected while waiting for resource

remove oracle table and put peek and run.

I'm pretty sure that what was meant there was to remove the Oracle stage.

Think about possible causes of deadlock. Might the same key be arriving from more than one partition? Are you trying to insert into the same table as one from which you are selecting?

Try running in single node.

This topic would be a great conversation starter for your DBA.