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 sta
John,
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
sy
On 18/05/11 13:10, Shree wrote:
I don't think we can help you because we don't know what HandleIds() does. I
note it may return -1 and causes all of the remaining ids in your batch to be
skipped. Some further comments below:
use strict;
use warnings;
my $dsn = 'dbi:Oracle:dbname';
my $user =
On 18/05/11 18:48, eric.b...@barclayscapital.com wrote:
Hey, Martin.
TEXTSIZE is a server-side variable that determines the data length
returned by a SELECT statement.
It appears to be roughly the server-side equivalent of LongReadLen,
where LongReadLen (per your notes below) is a driver settin
