Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Linked server to Oracle DB. Expand / Collapse
Posted Friday, October 25, 2013 11:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 19, 2015 5:22 PM
Points: 43, Visits: 103

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?

Post #1508537
Posted Monday, October 28, 2013 4:51 AM



Group: General Forum Members
Last Login: Tuesday, November 22, 2016 6:32 AM
Points: 5,519, Visits: 13,287
Very hard to tell without seeing the code.
Can you gie us more details?

Gianluca Sartori

How to post T-SQL questions
Post #1508804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse