Hi ! I also referred to the CPAN page before posting this query.
It's already working for me with Oracle 10g on Perl 5.8.4 on RHEL. Though somewhere on the web, I read a post by some perl developer that execute for him is not returning the number of rows affected. That's why, I asked the query. Regards, Amit Saxena On Thu, Jul 10, 2008 at 8:12 PM, Rob Dixon <[EMAIL PROTECTED]> wrote: > > Amit Saxena wrote: > > Hi all, > > > > I want to know how to get the count of number of rows returned in delete > / > > update sql in Perl DBI ? > > > > I have ready some articles on the internet and it states that the > "execute" > > function returns the number of rows affected though it's not confirmed to > > work for all the database. > > > > Is there any solution which will surely work on all databases ? > > I suggest that you simply test to make sure that it works on your database. > 'execute' will return -1 if the number of rows affected is unknown. > > Rob >