Link Server - Oracle

• Sanjay Masawan

  Newbie

  Points: 0

  More actions

  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

• salim

  Newbie

  Points: 0

  More actions

  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