Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sudhanshuntyl
Starting Member
5 Posts |
 Posted - 2009-09-15 : 02:59:46
|
| While I am trying to fetch the data from the oracle database by writing a query which contains the join of 5 tables, am not been able to get the data. And its not giving any error.I tried the same thing with the single table, and its fetching the records without any error. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-15 : 04:29:28
|
| If you are not getting an error, then the cause may be a JOIN or WHERE clause that is excluding all the records.Is any table empty?Do you have data that matches with all the ON conditions?Do you get any data returned when you run the query with just 2 tables, then 3 tables... |
 |
|
|
sudhanshuntyl
Starting Member
5 Posts |
Posted - 2009-09-17 : 02:29:54
|
| I missed to mention on the previous question that I was trying to get the data from SSIS package and wrote the query on data flow task OLEDB Source.The query is running perfectly on the oracle query analyzer and returning the records on the basis of the given WHERE and ON Condition.I tried the same query with the "ROWNUM" Clause for 10 records and getting the records. |
|
|
|
|
|
|
Unable to get the data from Oracle database