Re: Update is not working properly with Perl DBI

2011-05-19 Thread Martin J. Evans
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

Update is not working properly with Perl DBI

2011-05-18 Thread Shree
Hi, I have Perl program that will process one by one records from a queue table and set the flag 'T' to the processed records, Hence the same processed records should not be process again. And here the commit will happen in batch, the program will take batch of 10 records once and process it