ORACLEDB ERROR IN UPDATE TO ORACLE FROM SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

ORACLEDB ERROR IN UPDATE TO ORACLE FROM SQL

Author

Topic

preethiLeela
Starting Member

5 Posts

Posted - 2014-09-12 : 00:03:47

While we try to update Oracle Table from Sql using ORACLED Linked Server we are facing the following error .We ave checked for an alternate option wether user lock occurs in oracle table Also no such scenarios occurs to prevent update .

Error :
OLE DB provider "OraOLEDB.Oracle" for linked server "Oracledb" returned message "ROW-00014: Cannot update row as the data in the database has changed".
Msg 7343, Level 16, State 4, Line 81
The OLE DB provider "OraOLEDB.Oracle" for linked server "Oracledb" could not UPDATE table "[OraOLEDB.Oracle]".

Query :
Update a
set sent_for_sch ='N'
from openquery (oracledb,'select * from sm40_cus')

kindly some one suggest solution .

preethi

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-09-12 : 08:14:23

looks like lock issue.
can you try this.

Update a
set sent_for_sch ='N'
from openquery (oracledb,'select * from sm40_cus')
FOR UPDATE nowait;

Javeed Ahmed

preethiLeela
Starting Member

5 Posts

Posted - 2014-09-12 : 09:56:01

thanks for the help ahmed ,But i have tried the above query till then i am facing the same issue,kindly suggest if any possible options available

Update a
set sent_for_sch ='N'
from openquery (oracledb,'select * from sm40_cus FOR UPDATE nowait')a

preethi

preethiLeela
Starting Member

5 Posts

Posted - 2014-09-17 : 02:28:39

Distrubted transaction is not allowing in oracle .can some one help

preethi

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources