How to Delete from Linked server

AUSA_IT5
AUSA_IT5 used Ask the Experts™
on
From my 2005 SQL Server, I have a linked server to ORACLE.

I'm trying to issue a DELETE to a table from the ORACLE linked server. I have seen where this should be possible if all permissions are in line, as they are to the best of my knowledge, but I'm receiving the following error:

Cannot fetch a row using a bookmark from OLE DB provider "OraOLEDB.Oracle" for linked server "LINKED_SERVER".

If anyone has encountered and resolved this issue, please advise. Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
what does your delete statement look like?

Author

Commented:
Sorry, I forgot to include that:

I've tried this:

DELETE OPENQUERY(LINKED_SERVER,'SELECT * FROM TABLE_NAME')

and explicitly naming the columns.
DELETE OPENQUERY(LINKED_SERVER,'SELECT col1,col2 FROM TABLE_NAME')
Seems as though there used to be a bug with the OLEDB Oracle driver specified here -was or still is. Are you using the same driver specified on this article?
http://connect.microsoft.com/SQLServer/feedback/details/125675/oracle-10-2-ole-db-provider-update-error-linked-server
If it is, I wonder if you can obtain an more up to date version from either Oracle or MS.
Regarding your syntax: you are using the same suggestions I found over at OTN.  

Author

Commented:
This sounds like the same issue here. Let me verify the specifics mentioned in the article are the same as what I'm dealing with. Thanks

Author

Commented:
Thanks for the information. It appears there is not a recommended fix for the 64 bit ORACLE OLE DB provider, so I instead used the Microsoft ORACLE provider, which accomplished what I needed.

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial