On 19/05/11 10:28, P S Jameel Ahamed wrote: > I tried a simple SQL with 100 records in the table and refcursor. The SQL > response if I fire it in SQL developer or TOAD is 0.09 seconds > > But If I fire the same thing in Java program below is the analysis. You can > clearly see that the when starting the loop for the cursor which is a > sys-refcursor, its going back to the DB to fetch the rows again.
This mail list is intended for discussion of issues with the Perl DBI module and its associated drivers, such as DBD::Oracle. This message is completely off topic. Will you please stop spamming this list. -- Charles Jardine - Computing Service, University of Cambridge c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
