Could not fetch a row using a bookmark from OLE DB provider 'MSDAORA'.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Working with Oracle » Could not fetch a row using a bookmark from...

Could not fetch a row using a bookmark from OLE DB provider 'MSDAORA'.

Rate Topic

Display Mode

Topic Options

Author

Message

kienway

Posted Wednesday, August 19, 2009 6:49 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 8:05 PM
Points: 9, Visits: 237

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 »

Permissions