ORA-00060 dead lock detected,Oracle stage run sequentially
Posted: Thu Mar 01, 2012 1:17 am
Hi ,
I am having a job where a table is being updated in a Oracle connector stage.
The error the job is throwing :
ORA-00060 dead lock detected while waiting resource
The oracle connector stage is run in sequential mode and the array size is set 1 to avoid the duplicate delete key problem.Even after that the dead lock error is coming.No input row is used in the oracle stage to update the table .A hard coded sql statement is fired from the oracle connector.
Looking for you help.
Thanks and Regards
Avik Dasgupta
I am having a job where a table is being updated in a Oracle connector stage.
The error the job is throwing :
ORA-00060 dead lock detected while waiting resource
The oracle connector stage is run in sequential mode and the array size is set 1 to avoid the duplicate delete key problem.Even after that the dead lock error is coming.No input row is used in the oracle stage to update the table .A hard coded sql statement is fired from the oracle connector.
Looking for you help.
Thanks and Regards
Avik Dasgupta