I am working on a task, where I am connecting to Oracle database to update a row from SQL server 2000. I use OPENQUERY to connect and execute the update query in the Oracle database.
UPDATE OPENQUERY(ORACLE_LINKED, 'Select attribute1 from SettingMaster Where status = 1')
SET ATTRIBUTE1 = '25'
I have a issue when I try to update a record, but if it is locked by other application/user for update, my query waits infinitely.
I need a way to set a timeout here of 60 seconds, and proceed on the next record to update.
Any ideas are highly appreciated.