I notice the behaviour changes as I adjust the following parameter ...
$dbh->{LongReadLen} = 20000;
This is an Oracle database I am going against - version 10gR2
--- On Wed, 30/9/09, Tony Esposito <[email protected]> wrote:
From: Tony Esposito <[email protected]>
Subject: Limit on number of columns pulled using DBI::ODBC
To: "Beginners Perl" <[email protected]>
Date: Wednesday, 30 September, 2009, 11:06 AM
Is there a limit on the number of columns pulled from a table using DBI::ODBC?
Database: Oracle 10gR2
O/S: WIndowsXP
Perl: 5.8.9
I am getting an 'out of memory' error if I try to retrieve 40 columns or more
when using the following ...
my $dbh = DBI->connect( dbi:ODBC:orcl, "login", "password",
{ RaiseError => 1 }
) || die "Database connection not made: $DBI::errstr";
....
while (my $tableRef = $sth->fetchrow_arrayref) {
...
}
Send instant messages to your online friends http://uk.messenger.yahoo.com
