Jonathan Swartz wrote:
Something in which code is closing STDOUT? I know that mod_perl
redirects STDOUT to $r-print...
Incidentally the code to reprodce for mysql is even easier - just need
one connection. This will do it:
use DBI;
sub handler {
my $dbh = DBI-connect(
White, Richard L wrote:
Hi,
I'm new to the list, but not to Perl. I can not find an answer to my current
coding problem.
Is there an archive of this list?
I'm running this code on:
OS - Windows XP
DB - Oracle 10 on Solaris
I reinstalled ActiveState Perl yesterday and now have:
Hi,
I've spent some time on this today and I am getting nowhere. Before I
redouble my efforts I thought I'd post here just in case anything rings
a bell with someone.
We are using the latest DBI and DBD::Oracle to get data from an Oracle
data. All data is retrieved via reference cursor returned
Martin J. Evans wrote:
Hi,
I've spent some time on this today and I am getting nowhere. Before I
redouble my efforts I thought I'd post here just in case anything rings
a bell with someone.
We are using the latest DBI and DBD::Oracle to get data from an Oracle
data. All data is retrieved
Colin Murtaugh wrote:
Hi --
I'm running into a strange problem with a script that uses DBI and
DBD::Oracle. Once my script connects to my database, I can't use ctrl-c to
exit (or ctrl-z to background it). I end up having to open another shell
and kill the original process manually. As you
jeff wrote:
Hi all,
Hope someone can help.
I need to talk to both an oracle 8 and oracle 10 server in the same
script using their respective external connections capabilities (i.e.,
no user name or password -- system authentication on 8 wallet on
10 ).
Hacked up a version of DBD to
E R wrote:
Hi,
I'd like to trace all SQL calls made but also print out the
information available from caller(). That will give me good
information about why I am accessing the database.
Is there a way to do this with DBI (or DBD::Oracle in particular)?
Can I insert my own trace handler
I am getting one of these emails for every post I send to dbi-users and
this has been going on for more than a day. Does the list automatically
remove addresses which bounce repeatedly?
Martin
---BeginMessage---
An email you sent to '0rda-v...@xemaps.com' was refused by the remote mail
server.
you need
unicode support d) level of API you are prepared to program to e)
whether you need a support contract f) encrypted connections.
If anyone has any other options, I'd like to hear them.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Sorry for top posting but this thread is getting really long now and
getting difficult to follow.
Good point Alexander and noted but I still feel the issue is way beyond
whether UTF-8 encoded data is in the script or not as in my examples (as
in the ones you provided when you did the original
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
col wrote:
On Thu, 25 Jun 2009 10:10:03 +0100
Martin Evans martin.ev...@easysoft.com wrote:
Martin J. Evans wrote:
col wrote:
[8]
So, I thought you folks should hear about it all again. HTH...
else, sorry for the noise.
[8]
I spoke to Nick and he reminded
sufficient privs on the DB.
Once I get access to an 11g EE box I might be able to look into it deeper.
cheerrs
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
georg...@gmail.com wrote:
Hi,
I am trying to install DBD::Oracle against perl v5.8.8. I am
running Oracle
encoded as
it was not marked as utf-8 internally in perl.
I should have time to look at this more internally in DBD::Oracle
tomorrow but I thought I'd just throw this out now as a probable bug. Of
course, any help would be appreciated.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Steven Schlansker wrote:
Hello fine DBI users list,
I'm having a bit of trouble getting DBD Oracle 1.23 working with
Oracle Instant Client 10.2 (with SDK and SQLPlus) on
SunOS machinename 5.10 Generic_138889-03 i86pc i386 i86pc
I compile with a PREFIX set. Because I couldn't figure out how
will.sa...@sage.com wrote:
Hello,
I am using Perl 5.10, FreeTDS 0.82, DBI 1.605 and DBD::ODBC 1.13 with an MS
SQL Server 2008.
An SQL table I am working with includes columns with the binary data type.
Whenever I try to prepare a statement with placeholders for these columns,
the prepare
I have just uploaded DBD::ODBC 1.18_3 to CPAN. To see a list of changes
since 1.18 see below. Since I requested anyone using DBD::ODBC to test
the last development release I've had two replies - thank you. However,
I cannot believe there are only 2 users of DBD::ODBC. I maintain
DBD::ODBC for
= `$sqlplus_exe -S /nolog \...@define.sql 21`;
$ENV{ORACLE_HOME} = $x;
}
If needs to check for SP2-0642 as well and that fixes it:
if ($sqlplus_release =~ /(SP2-0750)|(SP2-0642)/) {
Hope this helps anyone else hitting this problem.
Martin
--
Martin J. Evans
Easysoft Limited
http
Tim Bunce wrote:
On Wed, Jan 28, 2009 at 10:30:49AM -0500, John Scoles wrote:
I think this is on purpose. Oracle numbers have a huge precision (38
decimal digits), so in general you cannot convert them to a perl
number
without losing precision. DBD::Oracle could be
don.walt...@falconjet.com wrote:
Just a quick thought. Instead of looping through the selected rows one
at a time, if the result-set is small(ish) it would probably work if
you
selected all the rows (fetchall_arrayref) then looped through them.
You
will use more memory but
don.walt...@falconjet.com wrote:
Is your dataset too large to hold in memory? Another approach would
be
load each result set into memory.
I'm not sure I understand your suggestion. Whether I'm storing the
results in memory or not, I still have to loop through the subroutine,
80 characters then you would
get a truncated error. The only way the around this was to set
LongTruncOk or LongReadLen.
Added a test case for rt 39897.
=cut
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
I have just uploaded a new development release of DBD::ODBC. All/any
feedback greatly appreciated. This fixes 2 issues on rt. I'm hoping this
will be the last development release before a 1.18 as the 1.17
development series now contains quite a few changes - see below.
Thanks to all who
Martin Gainty wrote:
any reason why you want to 'describe' before the executing the statement?
thanks
Martin
_
I'm not wishing to put words in Merijn's mouth but having attempted to
write a perl app which worked with a number of DBDs I have some
experience of how difficult this
Duncan Garland wrote:
Hi Martin,
Thanks, but I don't think its Oracle, I think it the way the returned
cursor is being handled. The statement is actually passed to a PL/SQL
procedure
my $cmd = qq {
BEGIN
report_package.execute_immediate(:sql,
:start_row,
:end_row,
ark40 wrote:
I know this has been discussed before but no solution was proposed. I
searched google but couldn't find anything useful either. I am trying
to compile DBD::Oracle 1.22 on an AIX 5.3 platform, using the Oracle
10g instant client. I initially ran into the OCI error so I went back
and
olwin wrote:
Sorry for my poor English.
After connect in SYSDBA to an Oracle 10.2.0.2 Database, all system
command return '-1' (No child processes).
Problem detect on a Solaris 10 x86 server :
Details :
perl -MDBI -e 'DBI-installed_versions'
Perl : 5.008006 (i86pc-solaris-thread-multi)
OS :
Sands
Have you tried running truss on the perl script to see what is happening
when system fails? I think it is worth a try. Also, the OCI libraries do
a lot of fiddling with signals and I can imagine SIGCHLD having an
effect on system.
Martin
--
Martin J. Evans
Easysoft Limited
http
/
DEFINE _SQLPLUS_RELEASE = 1002000300 (CHAR)
Oracle version 10.2.0.3 (10.2)
Looks like an Instant Client installation, okay
Your LD_LIBRARY_PATH env var is set to '/home/XXX/instantclient_10_2/'
==
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
--
Martin J. Evans
Easysoft
Andy Baumhauer wrote:
Martin,
Thank you so much for the spot on reply. The work you saved with that
reply is greatly appreciated.
Glad to hear it. resmg:wait quantum caught me some time ago when a
complicated query was taking over 8s every now and again and yet running
it outside of the
Andy Baumhauer wrote:
Running DBI 1.58 and DBD::Oracle 1.19 with Oracle 10g (10.2) on Fedora
7 64 bit OS:
Copying a table from one tablespace to another tablespace (two $dbh
handles). The table has 56 fields. I've simplified the process to:
fetch row from first dbh
execute row to second
POD is changed and I am happy to provide a patch against svn tree.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Ow Mun Heng wrote:
Current method.. pseudo code.
while (1)
{
$from_datetime = time;
$to_datetime = time + $time_interval;
$query = select count(*) from table where time = ? and time ?;
$sth = $dbh-prepare($query)
$sth-execute($from_datetime, $to_datetime)
$from_datetime = $to_datetime;
}
Alexander Foken wrote:
Is there a special reason why you do not use DBD::Pg? It should be
faster because it has less overhead and it supports Unicode better
than DBD::ODBC, should you need it. DBD::ODBC has seen no update since
about three years, while the current DBD::Pg is just one year old.
John Scoles wrote:
I think the key is
Oracle client 9.2.0.4.0 with Oracle server 9.2.0.7.0, 10.2.0.3.0
Don't think so as I'm not using Oracle 9.
seems this only pepps its head up when using this combination
can you recreate it using the instant client and Oracle server
9.2.0.7.0,
Garrett, Philip (MAN-Corporate) wrote:
Martin Evans wrote:
Hoping someone can help me here as I'm really stuck with this. I
have a large amount of code which reads some XML and inserts data
from the XML into a database. One particular insert fails:
[snip]
After much head
from mytest and remove
MANIFEST.SKIP etc.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Hi,
I am trying to debug a rather nasty problem using DBD::Oracle and
enabled tracing with DBI_TRACE=10=x.x. As soon as I did this I get the
following on stderr. Unfortunately, the code is doing quite a bit at
this point (see below). As you will see I am using DBIx::Log4perl so I'm
quite
Robert Denton wrote:
Okay, as it tunrs out maybe it is not all that difficult
afterall... With the help from someone form the FreeTDS developers
team I got it to work. All I had to do was the following:
I'm happy you are up and running.
~~
Since I just got this set up for
.
In this latter case you will have to hack the Makefile.PL or Makefile or
reinstall unixODBC under a single path.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
doing this I guess that won't bother you (unless Pg uses cursors
to navigate to the required row). To my knowledge, DBI does not support
fetching only a specific row via a cursor but I'm sure someone will
correct me if I'm wrong on that.
Martin
--
Martin J. Evans
Easysoft Limited, UK
http
'0');
return @lines;
}
Any ideas how I can call dbms_output_get from within
DBIx::Log4perl::st::execute? or is this impossible?
Thanks
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
= '0E0';
$inserted = 0;
tuple_status:
$VAR1 = [];
===
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
which is optional.
Check that when the driver calls _new_dbh it's not passing in
Err/Errstr/State attributes. Or if it is, that they're private
ref and not shared by other dbh.
Tim.
Thanks Tim.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Jonathan Leffler wrote:
On 1/23/07, *Martin Evans* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Thanks Jonathan,
Jonathan Leffler wrote:
DBD::Informix is careful about errors.
I would hope all DBDs are ;-)
Each statement handle keeps a copy of its most recent
'
and (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(TRXTIMEST' at line 1
Anyone see an obvious error in my code that I'm overlooking?
Thanks.
--
Kevin.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 28, 31-33, 37
Failed 5/37 tests, 86.49% okay
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
to something which is not
undef. Also the above calls to bind_param need to be changed to pass the
parameter by value. I'm attempting to find a permanent fix.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
but I'd look at your perl -V
output to see how perl itself was compiled first.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
this before
and I hope you can offer me some insight as I'm rather stuck with this
now.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On Wed, 2006-10-04 at 14:00 -0500, David Nicol wrote:
On 10/4/06, Martin J. Evans [EMAIL PROTECTED] wrote:
With DBI/DBD::Oracle all values read from the database are scalars. As
everyone will know, whether something read from the database is a string
or a number in Perl purely depends
and sometimes I don't. This itself means that I can end up with
strings in the JSON or numbers depending on what logic is applied to the
DB returned values.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
-Original Message-
From: Martin J. Evans [mailto:[EMAIL PROTECTED
driver or
client libraries to use port 5?
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 28-Sep-2006 Martin J. Evans wrote:
Stephen More wrote:
Environment:
RHEL 4
perl-5.8.5-24.RHEL4
perl-DBI-1.40-8
perl-DBD-ODBC-1.13-1
unixODBC-2.2.11-3.FC4.1
iSeriesAccess-5.4.0-1.0.i386.rpm
I am trying to call a simple stored procedure on an iSeries / AS400:
#!/usr/bin
On 29-Sep-2006 Stephen More wrote:
On 9/29/06, Martin J. Evans [EMAIL PROTECTED] wrote:
Stephen. I would try correcting your code which calls bind_param
incorrectly:
$sth-bind_param(1, \$a ); - $sth-bind_param(1, $a );
$sth-bind_param(2, \$b ); - $sth-bind_param(2, $b );
I changed my
to 3 to support dependence based
transformations.
dbdimp.c, line 11: warning: invalid white space character in directive
I think you'll find the file dbdimp.c has DOS line endings. You'll need to
convert it to use unix line feeds instead.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http
Stephen More wrote:
Environment:
RHEL 4
perl-5.8.5-24.RHEL4
perl-DBI-1.40-8
perl-DBD-ODBC-1.13-1
unixODBC-2.2.11-3.FC4.1
iSeriesAccess-5.4.0-1.0.i386.rpm
I am trying to call a simple stored procedure on an iSeries / AS400:
#!/usr/bin/perl -w
use strict;
$ENV{PERL_DL_NONLAZY}=1;
52 in 5.8.8 onwards
but the same code returned 51 in 5.8.7 and earlier?
Any over ideas that would help me track this down?
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 19-Sep-2006 Tim Bunce wrote:
On Tue, Sep 19, 2006 at 02:47:18PM +0100, Martin J. Evans wrote:
Hi,
Back in March this year Jonathan Gillespie reported the following
error in DBD::ODBC test suite:
Can't change param 1 maxlen (51-50) after first bind at
t/20SqlServer.t line 180.
(see
On 19-Sep-2006 Steve Hay wrote:
Martin J. Evans wrote:
On 19-Sep-2006 Tim Bunce wrote:
On Tue, Sep 19, 2006 at 02:47:18PM +0100, Martin J. Evans wrote:
I never really
got to the root of the problem but it appears:
in dbdimp.c did a:
svGrow(phs-sv, 50+1)
but
SvLEN(phs-sv) returns 52
ParamValues (I think)
but I see that has not been committed to DBD::ODBC in subversion
yet either. If you want the details again - let me know and I'll
dig them out.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On Tue, 2006-09-19 at 17:23 +0100, Martin J. Evans wrote:
On 19
On Mon, 2006-09-11 at 13:05 -0400, Berthold, Scott wrote:
How can I list all of the table names in an access database?
Thanks,
Scott Berthold
Have you tried the table_info method?
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On 04-Sep-2006 Tim Bunce wrote:
On Mon, Sep 04, 2006 at 05:21:17PM +0100, Martin J. Evans wrote:
It did raise an issue where I could do with some clarification. The slides
say:
Execute a statement for multiple values
$sth = $dbh-prepare(insert into table (foo,bar) values
On 05-Sep-2006 Tim Bunce wrote:
On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote:
I'll report the problems just as soon as I'm certain what they are. Here is
my summary:
1. insert into table values (?,?) where all values are valid and 3 rows of
values
returns: 3
On 05-Sep-2006 Martin J. Evans wrote:
On 05-Sep-2006 Tim Bunce wrote:
On Tue, Sep 05, 2006 at 11:20:04AM +0100, Martin J. Evans wrote:
I'll report the problems just as soon as I'm certain what they are. Here is
my summary:
1. insert into table values (?,?) where all values are valid
to not
recognising this error but if we knew what odbc driver you are using it
might help.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
-Original Message-
From: Martin J. Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 11:45 AM
To: dbi-users
I think you would be wise to ask Netezza SQL who wrote the ODBC driver
as they should be able to tell you what the error means. This is not a
driver I know.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On Tue, 2006-09-05 at 12:29 -0700, Loo, Peter # PHX wrote:
Hi Martin
It may have been included in the 3.0006_1 development release of DBD::mysql.
You also need to look up set character set utf8 and set names utf8 in mysql
documentation.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On Mon, 2006-09-04 at 14:13 -0400, Daniel Zeman wrote:
Martin J. Evans napsal(a):
On 31-Aug-2006 Daniel Zeman wrote:
Hi,
I wonder if anyone can help me.
I am using
- Debian Linux
- Perl 5.8.8
- DBI (I do not know how to figure out its version)
perl -MDBI -e 'print
How can you use two DBIx::xxx at the same time?
Say I had DBIx::fred and DBIx::bloggs both providing different
extensions to DBI which do not interfere with each other. Both
DBIx::fred and DBIx::bloggs do a:
DBI-connect
when what I really want to do is:
my $dbh = DBIx::fred-connect()
and
John Scoles wrote:
Using Oracle in /home/kauer/oracle/instantclient
sqlplus: error while loading shared libraries: libsqlplus.so: cannot
open shared object file: No such file or directory
I'm having trouble finding your Oracle version number... trying harder
Looking at the above means you did
Tim Bunce wrote:
On Fri, Sep 01, 2006 at 04:45:07PM -, Eriam Schaffter wrote:
my software crashes badly due to the fact that DBD::ODBC has not a
last_insert_rowid method:
It's called last_insert_id
Tim.
As you say, it is last_insert_id but I don't think DBD::ODBC implements
it
Lampang, Arman Elianto wrote:
snipped
erl5/5.8.4/lib/sun4-solaris-64int/CORE -DUTF8_SUPPORT
-DORA_OCI_VERSION=\8.1.
7.0\ Oracle.c
Oracle.xs, line 269: undefined symbol: startp
Oracle.xs, line 269: warning: argument #4 is incompatible with
prototype:
prototype: pointer to unsigned int :
per
row you use row-wise binding and it you have an array per column you use
column-wise binding.
I saw a mention in a previous posting recently suggesting DBD::ODBC
handled execute_array - I wasn't aware of this and will check but I
didn't think it did.
Martin
--
Martin J. Evans
Easysoft
Loo, Peter # PHX wrote:
Hi Rob,
It turns out that the IDs that would fail had an empty .odbc.ini file
within their respective home directories. That in turn was overriding
the file /usr/local/etc/odbc.ini. Once we removed the file from the
home directories of each of the Unix IDs, the program
of ini files.
Martin
-Original Message-
From: Martin J. Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 11:00 AM
To: DBI-Users
Subject: Re: Invalid authorization specification (SQL-28000)
Loo, Peter # PHX wrote:
Hi Rob,
It turns out that the IDs that would fail had
, locator, startp,
#endif
but it is not declared conditionally.
You make think warnings are better than errors but if I see a warning when I
compile something it immediately makes suspicious and it is sometimes justified.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
-fetchall_arrayref;
}
which will output the warning:
prepare_cached(select LAST_INSERT_ID()) statement handle
DBI::st=HASH(0x9ba8114) still Active at -e line 8
The same changes are required for DBD::mysql 3.0006_1.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
dbd_mysql_30006_patch
%% , $time_in_dbi/$perl_time*100 if
$perl_time;
I cannot find a time_in_dbi sub, only a scalar called time_in_dbi. To make it
work I had to change the above to use $time_in_dbi and not time_in_dbi(). Don't
know if this was correct but thought I ought to mention it.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
in the DBI pod. Perhaps it would be worth noting that there is also some SQL
you don't want to prepare_cached as it won't work properly - like this example.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
Tim.
On Tue, Jul 25, 2006 at 06:35:59PM +0100, Martin J. Evans wrote:
I know
using prepare_cached, execute,
fetch* compared with select*. As you say, with other databases and slower
networks it may make a bigger difference.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
Tim Bunce wrote:
Use DBI::Profile to see where the time is being spent.
Tim
This is not the correct list for this question - this list is for Perl DBI
users. Try http://lists.cpan.org/showlist.cgi?name=beginners.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 25-Jul-2006 Amar P. Singh wrote:
Hi All,
This is my first email to the group and I
needing to read the entire file.
I don't know how this ends up in the myodbc driver (and hence mysql client
libs) but it may be something similar.
As far as I know there is no interface to this in DBD::mysql or DBI.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
is
significantly faster? or I am flogging a dead horse?
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
have transactions working with mysql, innodb, DBI 1.4* to 1.5* and
DBD::mysql 3.* so I know it works but I don't change AutoCommit.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On Fri, 2006-07-21 at 14:15 -0500, Michael Muratet US-Huntsville wrote:
Greetings
I have had
to wait until #place2?
See above.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
Jonathan,
You are of course right.
I read the word transaction but saw the select and missed the do
to begin a transaction. My comments were based on a simple select
outside a transaction.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On Tue, 2006-07-11 at 09:18 -0700
user which is required to load your driver which
is not passed on to CGI scripts by default - like LD_LIBRARY_PATH - see
SetEnv in the Apache configuration guide and examine your environment
when logged in as your webuser by running env.
Martin
--
Martin J. Evans
Easysoft Limited
http
and back on again after fixes.
Thanks again.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 04-Jul-2006 Tim Bunce wrote:
On Tue, Jul 04, 2006 at 02:18:33PM +0100, Martin J. Evans wrote:
Thanks for the explanation. You have not however convinced me this behavior
is
right
On 05-Jul-2006 Tim Bunce wrote:
On Wed, Jul 05, 2006 at 01:38:04PM +0100, Martin J. Evans wrote:
Tim,
Thanks for the clarification and untested patch. I've tried it and it now
fails (returns undef) and the HandleError routine is called. The error I'm
getting now is:
executing ARRAY
- bind_param_array(2 ARRAY(0x829d534))= 1 at execute_array.pl line 23
- execute_array(HASH(0x829d5c4))= undef at execute_array.pl line 26
Thanks
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
execute_array (and similarly for HandleError).
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
- Original Message -
From: Martin J. Evans [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, July 04, 2006 6:37 AM
Subject: Is it correct that execute_array does
to me since I read the DBI docs and saw nothing which said
RaiseError does not work with execute_array, then discovered it didn't,
worked around this in my DBIx extension but would like to document why I
have this workaround.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
- the actual do which failed?
Any ideas?
NOTE: I am using DBIx::Log4perl.
Thanks
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
Ben wrote:
Hey guys, I'm very green at DBI stuff, so maybe this is a stupid
question. But after going through the DBI man page and searching the web
for a couple hours, I can't find the answer. All I'm looking to do is to
walk the result set from a select statement more than once. Every
When I said it works with DBD::mysql and DBD::DB2 I should have said
it worked. I've upgraded DBI and Log4perl since then so I need to
recheck. Will do so today.
Martin
Martin J. Evans wrote:
Tim Bunce wrote:
I'm saying that when you subclass the DBI (not a driver) then
the connect method
it.
and with DB2 you get:
subclass: selectrow_arrary
calls selectrow_array
DBI: selectrow_array
_do_selectrow_array
subclass: prepare
calls prepare which succeeds and hence returned statement handle is
good.
Martin
--
Martin J. Evans
Tim,
I'm sorry but I obviously being a bit thick here. I'm using DBD::Oracle. Are
you saying DBD::Oracle::dr::connect is not being called and I
need to create a DBIx::Log4perl::db::connected method and call
DBD::Oracle::dr::connect in it and if so how?
Martin
--
Martin J. Evans
Easysoft Ltd, UK
+0100, Martin J. Evans wrote:
Tim,
I'm sorry but I obviously being a bit thick here. I'm using DBD::Oracle. Are
you saying DBD::Oracle::dr::connect is not being called and I
need to create a DBIx::Log4perl::db::connected method and call
DBD::Oracle::dr::connect in it and if so how?
Martin
Hi,
This is a fairly complex setup to explain so I'll initially try and keep
it simple and can expand it necessary. I'm getting the error
$ perl a.pl
SV = RV(0x9fa6df4) at 0xa4450e8
REFCNT = 1
FLAGS = (TEMP,ROK)
RV = 0xa4451a8
dbih_getcom handle HASH(0xa4451a8) is not a DBI handle (has
301 - 400 of 540 matches
Mail list logo