I'm trying to import data from Oracle (Toad), using a select statement - When I pass one or two account in where I get the output. When I try to pass around 10 or more it doesn't fetch any records. It just fetches 0 lines - Not sure what the issue is .
My Statement ends with where c.account_id IN (222,333,444,555,666,777,888,999,1111,2222).
Any idea why the query does not fetch any records?. - Please find attachment for log file.
The problem is most likely buried deep inside the complex select statement. I would break the statement into its components and ensure that each of these is returning the expected record count. Then rebuild it step by step verifying the correct results at each step. Then you may find what is behaving incorrectly.
What kind of connection are you making? OLEDB or ODBC? I have seen the connection type to have an impact on the query... may be try to change the connection type and see if that makes any difference