develooper Front page | perl.beginners | Postings from September 2009

Limit on number of columns pulled using DBI::ODBC

Thread Next
From:
Tony Esposito
Date:
September 30, 2009 09:06
Subject:
Limit on number of columns pulled using DBI::ODBC
Message ID:
120008.95292.qm@web24602.mail.ird.yahoo.com
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 
Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About