none
hi all there is a issue about linked service to oracle RRS feed

  • 问题

  • 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".

    2011年12月28日 5:38

全部回复

  • 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!

    2012年4月12日 10:07