I am making call to stored procedure.I have set the fetchsize of result set to 1000.Even though the size is set , for first fetch only 10 records are fectched which is default size and for next fetch 1000 records are returned.
I am using
Tomcat web server and oci driver.
Can anyone pls help me i need all 1000 records in first fetch