Hi,
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.Clicode
WHERE a.LastUpdate <= b.LastUpdate