my $sthHandle = $dbh->prepare("SOME QUERY"); $sthHandle->execute() or die "$DBI::errstr"; while(my ($VALUE) = $sthHandle->fetchrow_array()) { my $sthHandle2 - $dbh->prepare("SOME QUERY"); $sthHandle2->execute() or die "$DBI::errstr"; while( my ($VALUE) = $sthHandle2->fetchrow_array()) { print "$VALUE"; } } #### panic: DBI active kids (2) > kids (1) at /usr/lib/perl5/site_perl/5.8.0/DBD/JDBC.pm line 890. #### DBI handle cleared whilst still active at ./dbProgram.pl.bak line 160. dbih_clearcom (sth 0x844d930 0x8478d30, com 0x8478ee0, imp DBD::JDBC::st): FLAGS 0x115: COMSET Active Warn PrintError PARENT DBI::db=HASH(0x82e004c) KIDS 0 (0 Active) IMP_DATA undef NUM_OF_FIELDS 1 NUM_OF_PARAMS 0