Post reply

Openquery On VIEW No Data Return

  • May 12, 2016 at 12:39 pm

    #318819

    Hi, I dont speak so much english...sorry

    I have a views and tables in a server Oracle, in my server (sql) I try to access by openquery, query works fine on table but view return only structure of view:

    Example:

    On table:

    SELECT * FROM OPENQUERY(BD_DIMACOFI,'SELECT * FROM tabla1')

    COLUMN 1 |COLUMN 2 |COLUMN 3

    data1 | data2 |data3

    data4 | data5 |data6

    data7 | data8 |data9

    On view:

    SELECT * FROM OPENQUERY(BD_DIMACOFI,'SELECT * FROM view1')

    COLUMN 1|COLUMN2|COLUMN3

    --------------NO DATA 🙁 -------------

    Any suggestion?

  • May 12, 2016 at 2:22 pm

    #1878772

    If you query the view directly on the oracle server does it return any rows?

  • May 12, 2016 at 2:30 pm

    #1878775

    On Oracle brings me data

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply