Thanks for taking out time to reply to the post.
I have tried with other tables also and it is having the same behavior i.e only the table column headers are retrieved but no data when we do a select with condition.
When i do the simple select once or twice all the data got retrieved but there after it never retrieved any data.On making the select without condition it gets in infinite loop.There are more than 10000 rows in this table.
As suggested by you i tried with another table and for the other table on making a select statement call i am able to retrieve the data.But with the condition only table headers get fetched but no data.
This is a remote database.
Thanks,
Aman
