hi all there is a issue about linked service to oracle

Question

i created some view from linked service,the data is from oracle.

select a.DIVISION_C, c.emplid, c.country, b.emplid
from dbo.Configuration_table a, dbo.V_PS_FBS_ELG_DTLS b, dbo.V_PS_PERSONAL_DATA c
where a.DIVISION_C = c.country
and b.emplid = c.emplid
and a.USERID = 'guanqun'
group by a.DIVISION_C, c.emplid, c.country, b.emplid
order by a.DIVISION_C

it hits error:

OLE DB provider "OraOLEDB.Oracle" for linked server "HCMS" returned message "ORA-01403: no data found".
Msg 7346, Level 16, State 2, Line 1
Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server "HCMS".

Answer 1

Hi,

  How you get data from oracle?

  Anyway, you can use diffrent way to get data from oracle:

  1.BCS connect to oracle database

  2.user solution: get data by Oracle DB provider, this is no diffrent with other .net application, you also can use linq2oracle.

  3.build a web service to be a mediator to provider oracle data to sharepoint.

hoe this can help.

---

just do it!