On 19-May-2006 Tim Bunce wrote:
On Fri, May 19, 2006 at 07:24:13PM +0100, Martin J. Evans wrote:
but I'm doing a select * from table and getting back a true value
which is 1. I thought for a successful select, execute would return
0E0 (which is true) but not 1. I was hoping to use true but
The subject maintenance releases of DBIx::Chart and DBD::Chart
are now (or soon should be) available on CPAN. These releases
fix a problem with some DBD's/DBMS's that don't support multiple
concurrent execute()'d, but un-fetch()'d, statement handles on a single
connection (the specific instance
I've uploaded DBIx::Log4perl 0.04 to CPAN.
DBIx::Log4perl uses Log4perl to log to a file, send email, even
log to DBI itself (see Log::Log4perl::Appenders) details
about what SQL you've prepared, parameters passed to execute or
execute_array, result-sets, transactions etc etc without the
How can I find the server pid for a sqlplus session which is logged on
remotely inside a perl program... I can find the local PID using $$ or
$PID, but how can I find the pid for the statement/database handle which
is actually logged onto the database doing the work...
Env: Oracle, Solaris
Hi,
I was wondering if someone can tell me how, where and what Perl DBI
stores the data returned from fetchall_arrayref. For example: if I
issues a SELECT statement such as select a.col1, b.col2, c.col3 from
someTable1 a, someTable2 b, someTable3 c where someCondition. From
this I get an
Hi Peter,
You have a valid concern regarding memory usage.
Don't use fetchall_arrayref when you are dealing with such large numbers of
rows. Some DBD's (eg DBD::Oracle) allow you to control the caching on the
client side by setting RowCacheSize (refer to DBI pod). This will give you
adequate
There is nothing to be gained here by using fetchall_arrayref, and
you will almost certainly have problems. You want to actually do:
while ($row = $sth-fetchrow_arrayref()) {
$sock-send(join($delim, @$row));
}
Mark
Loo, Peter # PHX wrote:
Hi,
I was wondering if someone can tell me