Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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, September 4, 2014 6:14 PM
Points: 39, Visits: 86

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: 2 days ago @ 10:05 AM
Points: 5,019, Visits: 10,552
Very hard to tell without seeing the code.
Can you gie us more details?

Gianluca Sartori

Get your two-cent-answer quickly
Post #1508804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse