e of using row_num
instead of LIMIT (which I believe is MySQL)?
thanks
--- On Wed, 30/9/09, Steve Bertrand wrote:
From: Steve Bertrand
Subject: Re: Limit on number of columns pulled using DBI::ODBC
To: "Tony Esposito"
Cc: "Beginners Perl"
Date: Wednesday, 30 September,
Tony Esposito wrote:
Please try to fix your email application (Yahoo) to wrap lines at ~76
chars per line ;)
> I am trying to retrieve all columns and some (not all) rows from an Oracle
> table which contain - among other things - 2 CLOB columns and print this to a
> flat file (ASCII file).
>
: Steve Bertrand
Subject: Re: Limit on number of columns pulled using DBI::ODBC
To: "Tony Esposito"
Cc: "Beginners Perl"
Date: Wednesday, 30 September, 2009, 8:39 PM
Tony Esposito wrote:
> Is there a limit on the number of columns pulled from a table using DBI::ODBC?
Althoug
Tony Esposito wrote:
> Is there a limit on the number of columns pulled from a table using DBI::ODBC?
Although I just received your own reply to this message, I'll respond to
this one as I have some questions.
> I am getting an 'out of memory' error if I try to retrieve 40 columns or more
> when
I notice the behaviour changes as I adjust the following parameter ...
$dbh->{LongReadLen} = 2;
This is an Oracle database I am going against - version 10gR2
--- On Wed, 30/9/09, Tony Esposito wrote:
From: Tony Esposito
Subject: Limit on number of columns pulled using DBI::ODBC
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", "passwo
