Post reply

Link Server - Oracle

  • December 5, 2004 at 8:02 pm

    #161956

    Hi gurus,

    I have a query as mentioned below

    SELECT * FROM EXIMLINK..DBO.SO_HDR

    EXIMLINK - name of the Link Server pointing to some Oracle Instance "INSTANCE1"

    DBO.SO_HDR - Name of the table and user.

    I have created a Link Server in SQL Server and used the above query in some stored procedure which works fine.

    But depending on some input parameters to the stored procedure I want to configure the Oracle Link. ie. Depending on the parameter how can I link to some other instance and user.

    Thanks

  • December 5, 2004 at 10:32 pm

    #532595

    An SQL Server linked server will point only to one Oracle Instance, so, you have to create another linked server to access another instance. But, to query another user table in Oracle, just indicate it in the fully qualified name as in

    SELECT * FROM EXIMLINK..AnotherOracleUser.SO_HDR

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

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