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
Author
Message
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: Wednesday, May 14, 2014 11:39 AM
Points: 26, Visits: 59
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.
Post #1508537
Posted Monday, October 28, 2013 4:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:31 AM
Points: 5,014, Visits: 10,514
Very hard to tell without seeing the code.
Can you gie us more details?


--
Gianluca Sartori

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

Add to briefcase

Permissions Expand / Collapse