October 13, 2016 at 8:02 am
i made linke server to oracle to schema "Ct2" with user dba .
when i do openquery select = all work
when i do update select * from openquery(LinkedSRV, 'update xfer_in_order set is_downloaded = 1 where is_downloaded = 0')
i get this:
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "update xfer_in_order set is_downloaded = 1 where is_downloaded = 0". The OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedSRV" indicates that either the object has no columns or the current user does not have permissions on that object.
if i run this update
update xfer_in_order set is_downloaded = 1 where is_downloaded in oracle with the user like at linked server its work also.
🙁
October 17, 2016 at 1:02 pm
I think the problem may be in the way you're trying to do the UPDATE. See EXAMPLE A in:
https://msdn.microsoft.com/en-us/library/ms188427.aspx
basically the OPENQUERY should have a SELECT in it not an update, and the entire OPENQUERY section works like the FROM clause of the UPDATE statement.
October 18, 2016 at 5:21 am
Chris Harshman (10/17/2016)
I think the problem may be in the way you're trying to do the UPDATE. See EXAMPLE A in:https://msdn.microsoft.com/en-us/library/ms188427.aspx
basically the OPENQUERY should have a SELECT in it not an update, and the entire OPENQUERY section works like the FROM clause of the UPDATE statement.
thanks man
thanks a lot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply