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

Re: Limit on number of columns pulled using DBI::ODBC

Thread Previous
From:
Tony Esposito
Date:
September 30, 2009 18:06
Subject:
Re: Limit on number of columns pulled using DBI::ODBC
Message ID:
889289.79005.qm@web24616.mail.ird.yahoo.com
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 <tony1234567893@yahoo.co.uk> wrote:

From: Tony Esposito <tony1234567893@yahoo.co.uk>
Subject: Limit on number of columns pulled using DBI::ODBC
To: "Beginners Perl" <beginners@perl.org>
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 


      
Thread Previous


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