Update with linked server via OraOleDB.Oracle issue

• G_Dubyah

  Mr or Mrs. 500

  Points: 584

  More actions

  January 31, 2015 at 5:46 am

  #314200

  Hi all,

  I have a strange problem when I run a update of a mssql table linking to Oracle via OraOleDB.Oracle. It fails when i use the original table but if I create a backup of the table with the sam PK's and constraints it works!

  The failure message is:

  OLE DB provider "OraOLEDB.Oracle" for linked server "TAFP_RxxxXX_VIEWS" returned message "ORA-01403: no data found".

  Msg 7346, Level 16, State 2, Line 5

  Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server "TAFP_RxxxXX_VIEWS".

  -- the update updates 3 rows with my backup table. Weird!

  UPDATE TT

  SET TT.InvoiceNumber = ADG.INVOICE_NUMBER

  --select ADG.INVOICE_NUMBER, TT.InvoiceNumber, TT.BatchNumber

  FROM dbo.TopUp_Transaction_GW TT WITH(NOLOCK)

  JOIN dbo.BatchFile BAT WITH(NOLOCK)

  ON BAT.BatchNumber= TT.BatchNumber

  JOIN [TAFP_xxxXX_VIEWS]..[TAFP].[VW_TAFP_GET_TOPUPRESULTSET] ADG WITH(NOLOCK)

  ON TT.TRN_Number = ADG.DEPOSIT_NFN_NUMBER

  WHERE ADG.DEPOSIT_NFN_NUMBER IS NOT NULL

  AND TT.BatchNumber = 'xxx_30JAN_1601PM'

  Any ideas?