Linked server to Oracle DB.

• nishav2

  SSCrazy

  Points: 2224

  More actions

  October 25, 2013 at 11:12 am

  #395725

  Hi,

  I have a dynamic SQL query which pull data from oracle DB through linked server.

  Dynamic SQL query works fine and I am able to pull the data into SQL Server table.

  But the issue is, after the data pull is done, if I run the same query it pulls more data.

  What would be the issue? Is it because of linked server??

  Same Code but different output. This is the issue.

  Can someone give me some idea?

  Thanks.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 28, 2013 at 4:51 am

  #1661899

  Very hard to tell without seeing the code.

  Can you gie us more details?

  -- Gianluca Sartori