InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 05:54:46 GMT20http://www.sqlservercentral.com/Forums/Topic773971-1043-1.aspxHi,I currently need to perform updating the link server based on the local table condition. I get the error when i using openquery. Can anyone help? Thanks.The error message is as per below:Could not fetch a row using a bookmark from OLE DB provider 'MSDAORA'. [OLE/DB provider returned message: Multiple-step operation generated errors. Check each status value.]OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowsetLocate::GetRowsByBookmark returned 0x80040e21: ].Query:UPDATE OPENQUERY([LS-ORACLE],'SELECT Status, LastUpdate FROM ebh.CliInfo WHERE Src = ''A''') SET Status = 'E', LastUpdate = GETDATE()FROM (SELECT * FROM OPENQUERY([LS-ORACLE],'SELECT * FROM ebh.CliInfo WHERE Src = ''A''')) a INNER JOIN LocalTable b ON a.CliCode = b.ClicodeWHERE a.LastUpdate <= b.LastUpdateWed, 19 Aug 2009 18:49:17 GMTkienway