Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Could not fetch a row using a bookmark from OLE DB provider 'MSDAORA'. Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 6:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 8:54 PM
Points: 9, Visits: 240
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
Post #773971
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse