fetchrow not proceeding beyond 9th record

dn_perl_at_hotmail.com
Date: 11/12/03 

Date: 12 Nov 2003 01:22:16 -0800

I am trying to fetch rows using $sth->fetchrow.
If I run my sql query from 'sqlplus' prompt, it returns 58 unique
records. But if I do :

while ($sth->fetchrow())

the loop is terminated after processing only 9 (not 58) records.

Why could this be happening? Is there any variable associated with
Perl DBI which is set to 9 and fetches only 9 rows by default.
If the number was 8 or 16, that would be less of a surprise.
But I am unable to make out while the loop exits too early
and why it exists after fetching 9 records.

Please advise.