Generally the rows method is unreliable - here's a section from
'perldoc DBI':
rows
$rv = $sth-rows;
Returns the number of rows affected by the last row affecting
command, or -1 if the number of rows is not known or not
available.
Generally, you can only rely on a row count
test DBD::Oracle 1.16rc7 on HP-UX 11.00 and Oracle 8.1.7.0 (server and client
the same revision) using perl 5.6.1
Works, but only if I apply the following patch. Regards, Silvio
--- 31lob.t~Tue Jul 13 01:22:34 2004
+++ 31lob.t Mon Sep 13 12:34:00 2004
@@ -3,3 +3,3 @@
use strict;
-use
Robert,
I do have the 1.16 rc (beta) up there and it is 51K, not 193K. It's bad and I have to
look at it.
Jeff
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 12, 2004 8:16 AM
To: [EMAIL PROTECTED]
Subject: Re: DBD::Oracle gz file sizes
Sorry, I was talking about the esoftmatic ftp site.
It's fixed up there.
The fix was to 'back-off' the 1.16 trial in the 5.8.3 directory, since I don't have
that
perl anymore and 5.8.4 has the new 1.16 version for testing, with the right sizes. It
was
a recent error in my build process.
test DBD::Oracle 1.16rc7 on HP-UX 10.20 and Oracle 8.0.6.0 (server and client the same
revision):
Unresolved symbol for OCILobIsTemporary and OCILobFreeTemporary. This symbols does not
exists in any shared or static library of Oracle 8.0.6 and also not in any object:
% find $ORACLE_HOME -name
On Thu, 15 Jul 2004 22:09:04 +0100, Tim Bunce wrote:
Please try
http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc5-20040715.tar.gz
Oracle.o(.text+0x79a1):Oracle.c: undefined reference to
`_OCILobWriteAppend'
That should be fixed (one way or another) in 1.16. Please try it.
I'm trying to write a Perl program that filters the contents of an input
file. After each line from the input file is parsed, the fields of the
line are submitted to if statements to determine which output file to
write the line to. It would be pretty straightforward except for the
All,
I'm trying to understand the Apache::DBI mechanism
which caches and returns $dbh handles. My concern is
that Apache DBI uses the connection options, like
AutoCommit=1 as part of it's caching 'key' mechanism.
Thus would I be right in thinking that if I create a
$dbh with AutoCommit=1, this
I owe you a great big Thank-you, Jonathan.
I succeeded in applying the patches you described. They worked beautifully.
-Will
BTW I've noticed a couple of problems with installation in my local
environment here. If I confirm them, how soon should I try to send the
email before the next
On Sep 13, 2004, at 8:30 AM, Martin Moss wrote:
All,
I'm trying to understand the Apache::DBI mechanism
which caches and returns $dbh handles. My concern is
that Apache DBI uses the connection options, like
AutoCommit=1 as part of it's caching 'key' mechanism.
Yes it does, it uses the sorted list
All,
Can I do this?
$sth-bind_param_inout($#execute_args+1,\$new_id,38);
$sth-execute(@execute_args);
When I try I get the following error
Can't rebind or change param :p6 in/out mode after
first bind (1 = 0) at ...
I wish to pass several arguments, into the sth, I wish
to use
On Mon, Sep 13, 2004 at 09:58:56AM -0400, [EMAIL PROTECTED] wrote:
CREATE TYPE rule_expression_t AS OBJECT (
CREATE TYPE rule_t AS TABLE OF rule_expression_t;
CREATE TABLE filter_rules (
)NESTED TABLE rule STORE AS filter_rules_nested_table;
What I would like to do, if possible, is
On Mon, Sep 13, 2004 at 06:22:13PM +0100, Martin Moss wrote:
All,
Can I do this?
$sth-bind_param_inout($#execute_args+1,\$new_id,38);
$sth-execute(@execute_args);
When I try I get the following error
Can't rebind or change param :p6 in/out mode after
first bind (1 = 0) at ...
You could use a pl/sql procedure that returns a cursor_ref which decodes everything
correctly.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 12:23 PM
To: [EMAIL PROTECTED]
Cc:
Jeff Urlwin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Robert,
I do have the 1.16 rc (beta) up there and it is 51K, not 193K. It's bad
and I have to
look at it.
Jeff
Is the esoftmatic site the generally the right place to get that DBD? I
see Tim Bunce has his own links
Hello:
RH9 + MySQL-4.0.21
Couple of days ago, I posted a message indicating that I was getting errors
when I install Perl modules. I did not include the error, so here it is;
% perl -MCPAN -e shell
Note: Answer no to auto-configure perl.
cpan install Bundle::CPAN
Kirti,
When I've run into really wierd stuff like this with CPAN, I changed my
mirror. Its in wherever_perl_is_installed/CPAN/Config.pm. Change the
urllist to use another one. My primary mirror stopped being updated.
Switching to #2 solved my problems.
HTH,
Dave
On Sep 13, Kirti S. Bajwa
From: Tim Bunce [EMAIL PROTECTED]
On Mon, Sep 13, 2004 at 06:22:13PM +0100, Martin Moss wrote:
All,
Can I do this?
$sth-bind_param_inout($#execute_args+1,\$new_id,38);
$sth-execute(@execute_args);
When I try I get the following error
Can't rebind or change param :p6 in/out
I am looking at upgrading my present Perl compiler from version
5.6.1 to version 5.8.5. The new version will be built with GCC
3.3 into a shared /usr/local running on a cluster of various
UltraSparc models running Solaris 9. I am looking for advice on
options for building the new Perl to ensure
19 matches
Mail list logo