in reply to DBI and Oracle: Problem fetching ALL records.

Did you 
use strict;

[download]
Did you run with the debugger on?

Does it always stop in the same place?

It would be especially helpful to see the code around your main loop that's pulling the records.

How do you know that it's stopping at 100 records? Could it be writing more records out but not flushing the buffer?

throop

Replies are listed 'Best First'.
Re^2: DBI and Oracle: Problem fetching ALL records.
by Anonymous Monk on Jan 06, 2007 at 15:36 UTC
    I know it stops at 100 because each entry has a # associated with it that links it to the next page. Its bizzar, because It will print 100 of the records out and the rest of the page will be blank (like perl is leaving room for the rest of the data, but its just not there.) I'm not at my computer at the moment, but I will post my code when I get here....Oh yes, I am using strict and there are no errors when I test it in unix.
[reply]

In Section Seekers of Perl Wisdom