I am using Oracle 10 , runing a query , select * from view_name , from SQL Plus and query is returning data. From Java (OCI and also Thin) The query is returning no data, and NO ERRORS also. The alias is not the issue as I am able to get specific data from another table for the same DB.
Are you sure you are connected to right database when using JDBC.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Joined: Nov 08, 2008
Actually yes, I am connected to right DB, I am even able to get Production data from different tables and views throws JDBC (which are identical to what I get from PL/SQL), however, when coming to this specific (and kind of slow and complex) view, there are no records returned from JDBC and the query execution time is 50 seconds with no Exceptions thrown. But if I query the view from PL/SQL the query returns 181 rows with execution time = 900 seconds.