he same C compiler to build DBD::Oracle
that was used to build Perl. Did you build Perl or did you get it
pre-built from a repository for AIX? If the latter then you need to use
the same compiler as was used to build Perl. You are mixing 32 bit
compiled code with 64 bit compiled code as it stands.
Martin
--
Martin J. Evans
Wetherby, UK
Not unless you are using execute_array. The code you posted didn't look
like it was.
Martin
--
Martin J. Evans
Wetherby, UK
contributed.
Martin
--
Martin J. Evans
Wetherby, UK
I have just uploaded DBD::Oracle 1.79 to the CPAN.
[BUG FIXES]
Fix Avoid GCC-ism so that HP-UX can compile (GH#92, Dean Hamstead)
Destroy envhp with last dbh (GH#93, GH#89, Dean Hamstead,
CarstenGrohmann)
Thanks to everyone who contributed.
Martin
--
Martin J. Evans
Wetherby, UK
Has anyone done any work on converting SQL queries between RDBMS and perl?
My particular interest is DBD::Pg but anything would be of use
It would be very useful when I am testing complex SQL, it's very easy to
miss a \ or quote between the two
Thanks
Mike
On 15/11/2018 23:54, Daniel Kasak wrote:
Hi Martin. Sorry for the very long delay. We had abandoned the ODBC
driver in favour of the native DBD::DB2, and I've been working on this
project outside my normal work hours anyway, so got bogged down in
other issues ...
I've uploaded th
HI
If I use printf to round a numeric value before inserting into postgres
table it is altered to 1 rather than the value when it is put into a table
example
CREATE TABLE public.chksize
(
size numeric(10,2), #does not matter what field type
path1 character varying COLLATE pg_catalog."defau
?
--
Jeff Macdonald
Ayer, MA
do may be implemented by the driver in XS (c code) in which case you would not
be able to step into it. Drivers can override the DBI methods.
Martin
the simplest test you can and rerun with
DBI_TRACE=15=trace.log perl mycode.pl
and show me the trace.log file.
Martin
JSON. JSON treats numbers and string
differently and I required numbers to be numbers and not strings.
There is of course, the type argument to bind_param as well.
Best of luck.
Martin
://www.foo.com
-
is this doable?
love to hear from you
Martin
#!C:\Perl\bin\perl
use strict; # You always want to include both strict and warnings
use warnings;
use LWP::Simple;
use LWP::UserAgent;
use HTTP::Request;
use HTTP::Response;
use HTML::LinkExtor;
# There was no reason for this t
s the developer header files and libs that DBD::Oracle uses to
compile the c code.
You should probably get the sqlplus package as well as it is used if found, to
determine the version of Oracle client you are using.
Without it, the Makefile might assume you are oracle 8.
Martin
, 2017 5:17 AM, "Martin J. Evans" mailto:boh...@ntlworld.com>> wrote:
On 02-Mar-17 10:54 PM, Douglas Wilson wrote:
DBD::SQLAnywhere seems to work ok for Sybase IQ, but if I first
create a
DBD:Oracle handle, the SQLAnywhere connect hangs for a while, and
rd similar reports
before. I think it had something to do with the method used to connect
to Oracle and if that method is chosen it captures SIGCHLD and maybe
another signal as well.
Martin
--
Martin J. Evans
Wetherby, UK
mic_config from META.yml.
Martin
f)
but if someone was brave enough to try then all the best to them.
Martin
n time - only those
products which have 'ALL' of multiple given tags.
the SQL suggested on the page is:
|SELECTa.*FROMproducts a INNERJOINproduct_tags b ONa.product_id
=b.product_id WHEREb.tag_id IN(1,23,54)GROUPBYa.product_id
HAVINGCOUNT(1)=3|
thank you.
Rajeev
--
cheers
Martin
PPORT
-DORA_OCI_VERSION=\"10.2.0.5\" -DORA_OCI_102 Oracle.c
/usr/ucb/cc: language optional software package not installed
*** Error code 1
make: Fatal error: Command failed for target `Oracle.o'
You need to install a C compiler - the one your Perl was built with is
most likely to work.
Martin
--
Martin J. Evans
Wetherby, UK
--- Begin Message ---
On 28/01/16 15:08, Jerrad Pierce wrote:
Hello Martin,
$DBI::VERSION = 1.634
$DBD::ODBC::VERSION = 1.52
It would also be useful to know the column type in your access DB.
I'm updating a LONGBINARY column in a Jet 4 (MDB) database.
Thanks
Thank you
I forgo
.
If this produces nothing in x.log you've probably got an older DBI in which
case use:
set DBI_TRACE=15=x.log
perl mycode.pl
It would also be useful to know the column type in your access DB.
Thanks
Martin
re you get the MS Access driver from.
Be careful, as there are 2 ODBC driver managers, one for 32 bit apps and one
for 64 bit apps. You need to use the one that is the same as your Perl.
Martin
your ODBC driver manager?
Are you using a 64 bit perl and don't have a 64 bit Access driver for instance?
Martin
On 02/11/15 07:51, Ismail Chamseddine wrote:
I am using Active Perl 5.18.4 64 bit on Windows 7 64 bit
The connect string code
my $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);
database= C:\Users\User\Documents\Mydb.accdb');
On Fri, Oct 30, 2015 at 4:07
ODBC
administrators. What versions of DBI and presumably DBD::ODBC are you using?
Martin
and sqlplus zips and unzip them then point DBD::Oracle at them by
setting LD_LIBRARY_PATH.
Did you download the sqlplus RPM (assuming there is one) as DBD::Oracle
uses sqlplus during the install to work out what version of the Oracle
client you have?
Martin
--
Martin J. Evans
Wetherby, UK
_ROW_COUNT.
[DOCUMENTATION]
Add tables and table_info section to deviations from the DBI spec.
[MISCELLANEOUS]
Change column name in t/rt_101579.t as "method" is a reserved word
in. Teradata Thanks to Zhenyi Zhou.
Remove duplicate dynamic_config from META.yml.
Martin
or
been fixed in all that time.
I've recommended William tries a newer version as I suspect the preparse code
it failing since those ? should not get to Oracle.
Martin
, I expect, as you do, that one of the chrs in the SQL is
not what it seems.
Sorry, as log file was sent to me I answered it and did not cc the list.
Martin
On 03/06/15 14:38, William Bulley wrote:
According to "Martin J. Evans" on Wed, 06/03/15 at 09:15:
So, when this fails, what is the value of $value.
I just ran it again. The value is 547.
Sounds ok but the error is "invalid string"
ORA-0911
You tried to execute
hat to look for.
Regards,
web...
Tell us the column type of 'column' and the value of $value when the original
code fails. If this does not enlighten you, reduce this to a small reproducible
script and re-run with ora_verbose set to 7. Paste the output somewhere we can
view it.
Martin
On 18/05/2015 16:03, Mike Martin wrote:
Hi
Is it a known issue with running bcp while an active db connection
I have a script that basically
opens a db connection
selects some data
parses/transforms the data
writes to a text file
--
runs bcp to import the data into same
Hi
Is it a known issue with running bcp while an active db connection
I have a script that basically
opens a db connection
selects some data
parses/transforms the data
writes to a text file
--
runs bcp to import the data into same database
--
does some upd
that field is not a
unique key you will lose rows.
Martin
On 20/04/15 17:54, Mike Martin wrote:
I have the following script (extremley simplified)
foreach my $key (sort {$a<=>$b} keys %run){
my $inp;
$inp=$dbh->selectall_arrayref("select id, [description] from Kaonix_import_base where
idint between ? and ? ",undef,$run{$key}-&g
I have the following script (extremley simplified)
foreach my $key (sort {$a<=>$b} keys %run){
my $inp;
$inp=$dbh->selectall_arrayref("select id, [description] from
Kaonix_import_base where idint between ? and ? ",undef,$run{$key}->[0],
$run{$key}->[1]) ;
addrec($inp); -- sub to run very heavy r
_1 2014-11-14
[BUG FIXES]
RT100186 - handle VARBINARY(MAX) parameters with SQL Server native
client. Identify "libmsodbcsql*" as the MS ODBC Driver for Linux as
there are some specific workarounds for MS Native Client ODBC driver.
Martin
On 01/04/15 05:36, Joel Plotkin wrote:
Hi Martin,
I've attached a odbc device driver log (sql.log) and the dbi trace log at level
15 (x.log).
Hope this helps,
Joel
Joel,
Thanks for the logs but I'm not sure you are going to be too pleased with my
analysis.
There are a few poin
the ODBC level as then we
can try and find out why SQLFreeHandle is failing. You can do this by going to
the ODBC administrator (make sure you pick the right one 32 bit or 64 bit
depending on what your perl is) and selecting the tracing tab, enter a file and
click on start then run your script.
Martin
oel
Ps- we too used PerlBrew to install Perl 5.20 - specifically:
perl 5.20.2
DBI 1.633
DBD::ODBC = 1.50
Martin
see if they can find 1.53_3 for me.
sorry, typo from me - that is the version I am using.
3) *** I'm using perl 5.10.1 ... maybe this is the issue. I'll upgrade to
perl 5.19.10 and see if the issue goes away.
I'll keep you posted,
Joel
I've since tried on a load of per
is a good place
to send your issue. When I run your script as it stands (with edits below) I
get:
opening new db connection
at mje/joel.pl line 23.
This is a test 3
at mje/joel.pl line 45.
This is a test 4
at mje/joel.pl line 47.
Can't return outside a subroutine at mje/joel.pl line 56.
perl 5.19.10
DBI 1.631
DBD::ODBC 1.53_3 (which is latest git)
I'm going to SQL Server enterprise edition via the Easysoft SQL Server driver.
Obviously I changed the logon details and the SQL.
BTW, I don't think you need those calls to finish (see finish in DBI docs).
Martin
ith the rows with that house id. In other words, I
think this is generally bad design.
Martin
his error.
Can't get DBI::st=HASH(0x7fcee73ce078)->{COLUMN_SIZE}: unrecognised attribute
name at ./ut_testdictsync line 19.
because of the bit you quoted "but we stick with PRECISION for backwards
compatibility"
Martin
On 01/22/15 08:26, Michael Gerdau wrote:
In in "standa
t forward, but it would make application and interface
layers so much easier if they could just say 'does this DBD do X' and
maybe 'how do I make it do X'.
Martin
--
Martin J. Evans
Wetherby, UK
On 2014-12-21 7:17 AM, Greg Sabino Mullane (the tenth man) wrote:
Tim Bu
BD::ODBC maintainer I would prefer not to have to map ODBC 2 names to 3
- it would set a precedent that would lead to many other changes.
Thanks, Kurt Starsinic
Martin
mber of allowed parameters.
Martin
formix but all those missing symbols are in dl.so. Try to find a
way to get the Makefile.PL to add -ldl to the link line. Maybe just setting
LDFLAGS=-ldl and exporting it before running Makefile.PL will do it.
Martin
On 06/06/14 12:17, Ranjitha wrote:
Hi Martin
Screen shot from yast :
showing sqlplus is installed.
I have sqlplus installed in my server, then why the error?
Same way I have installed sqlplus in other servers also, no issue there.
Thanks and regards,
You've misunderstood me. I w
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open
shared object file: No such
file or directory
This is your problem. You need to get sqlplus working in your environment
before attempting to build DBD::Oracle.
Martin
ies and all
DBD::Oracle does is make the appropriate calls to set it up and call the
callback. As such Oracle docs will be your friend.
Try it and see and report back. Up to this point I only know of myself
as having used TAF with DBD::Oracle. There may be an article on the
Easysoft web site.
Martin
--
Martin J. Evans
Wetherby, UK
um number of allowed parameters.
Martin
ck but it should get you further. If you are
struggling with this mail the Makefile to me (only) and I'll take a look.
make: The error code from the last command is 255.
Stop.
[root@ews-pgh1-esmd2] /home/rj46/DBD-Oracle-1.70
q32 option is mandatory?
no idea what your question is there.
Can you please guide how to proceed on this?
Thanks & Regards,
Martin
--
Martin J. Evans
Wetherby, UK
.
I'm now going to sit back and wait for the usual rush of reports from everyone
who didn't test it.
See below for changes since last full release.
Martin
1.47 2014-02-19
Full release of the 1.46 development releases.
[MISCELLANEOUS]
Just some tidying up of dbdimp.c - should
instant client path. I wondered how it
had managed to do that then realised my PATH still pointed to the old instant
client and it had managed to run sqlplus from there and chosen the old path.
It was easily solved by setting my PATH to the new instant client too.
Martin
On 05/02/14 14:08, David Nicol wrote:
On Wed, Feb 5, 2014 at 7:25 AM, Martin J. Evans
wrote:
That is indeed interesting. When I run the following with DBD::ODBC to MS
SQL Server:
use strict;
use warnings;
use DBI;
my $h = DBI->connect();
eval {
$h->do(q/drop table mje/);
};
$h
ee I did the same.
vs
if ($price_sth->fetch)
There is the odd chance that he is doing the SQL against a 'view', 'cursor'
or alike but I doupt that is it.
Perhaps David can tell us more.
Martin
> Date: Wed, 5 Feb 2014 13:25:03 +
> From: martin.ev...@ea
y ($row) = $s->fetchrow_array;
print "$row\n";
$row = $s->fetch;
print "$row\n";
I get:
1
Use of uninitialized value $row in concatenation (.) or string at
mje/fetch_off_end.pl line 20.
However, I get the same with DBD::Oracle so how is you code different from the
above.
Martin
ay I don't understand why. I think there is more to this than it so far looks
but without a way of reproducing it myself I won't be spending any more time on
it. If it is reproducible in a standalone script I will happily look again.
Martin
On 28/01/2014 10:56, hhferreira wrote:
Hi John & Martin,
Our application is single threaded and does not uses connection pool
neither statement caching.
Below I'm sending the code where new connections are created.
Hi Hélder,
I'm answering now as I don't want yo
"-1", -1, errmsg, Nullch,
Nullch);
return 0;
}
and I don't particularly like that casting but I don't think it explains the
problem.
Martin
We will proceed with the test environment setup using the latest perl and
module versions, Martin mentioned this could be done wit
/blib/arch -Idir2/blib/lib -Idir2/blib/arch myapp.pl
M
On 24/01/14 12:26, hhferreira wrote:
Hi,
We have already tried using ora_maxarray_numentries and other similar
attributes unsuccessfully.
Martin found that immediately before the error the following message is written:
{{ execute callback CODE(0xb832be8) being invoked
However we have done
e, as this would definitely be the best way to go. It would be worth
putting a bit more effort into this.
Any help would be highly appreciated!
Thanks in advance.
Best Regards,
Hélder Hugo Ferreira
Martin
Just so everyone knows, I pointed hhferreira here in the following thread on
perl monks:
https://perlmonks.org/?node_id=1071794
Martin
On 24/01/14 10:29, hhferreira wrote:
Hi Guys,
Hope you can provide us some enlightenment!
We have the following code which basically calls an oracle
BC (if you know different and can point me
at it I'll take a look). The traditional way around this is to use
temporary tables.
Martin
--
Martin J. Evans
Wetherby, UK
_arrayref, DBI returned:@retarr contains: markb ro
Installed versions
====
perl -MDBD::mysql -le 'print $DBD::mysql::VERSION;'
4.013
perl -MDBI -le 'print $DBI::VERSION;'
1.609
Martin
--
Martin J. Evans
Wetherby, UK
MS Access (which does not support schemas - even
for a simply ping (which uses SQLTables)). Now we call
SQLCATALOG_NAME and SQLSCHEMA_USAGE on connect to ascertain support
which modifies SQLTables call.
[MISCELLANEOUS]
Added test 45_unicode_varchar.t for MS SQL Server only so far.
On 20/11/13 09:39, Michiel Beijen wrote:
Hi,
I ran into this issue with DBD::ODBC;
I read Martin asked about feedback on the 1.46_1 devel release. I
tested my code against both versions 1.43 and 1.46_1 an the results
are the same.
Thanks for this. It has raised questions that needed
On 17/11/2013 08:32, Meir Guttman wrote:
Dear Martin
-Original Message-
From: Martin J. Evans [mailto:boh...@ntlworld.com]
Sent: שבת 16 נובמבר 2013 12:34
To: dbi-users@perl.org; DBI Developers Mailing List; dbi-annou...@perl.org
Subject: DBD::ODBC 1.46_1 released - You REALLY need to
ot support schemas - even
for a simply ping (which uses SQLTables)). Now we call
SQLCATALOG_NAME and SQLSCHEMA_USAGE on connect to ascertain support
which modifies SQLTables call.
[MISCELLANEOUS]
Added test 45_unicode_varchar.t for MS SQL Server only so far.
Martin
--
Martin J. Evans
Wetherby, UK
On 06/11/13 14:36, Jan Holčapek wrote:
Hi Martin,
On Wed, Nov 6, 2013 at 3:05 PM, Martin J. Evans wrote:
I believe this is a bug in your ODBC driver.
I kind of expected that. I'll file a bugreport to Vertica Support.
good, that was part of what I was hoping to achieve when I did
On 06/11/13 12:36, Jan Holčapek wrote:
Hi Martin,
3. now run your basic script and send me /tmp/unixodbc.log
attached is the log file you've requested. Please let me know your
findings, thanks!
--Jan
Hi Jan,
Your log shows:
[ODBC][7270][1383740710.126962][SQLExecDirect.c
5/Changes#pod1.30_6-2011-06-04
So my question is: is it me, ODBC manager, DBD::ODBC or Vertica doing
something wrong?
Any insight is more than welcome!
Thanks
Jan
To rule out DBD::ODBC being at fault in its ODBC calls I'd need to see a ODBC
driver manager trace. You can do this by:
1. ru
the github repository (which you'll find at
https://github.com/pythian/DBD-Oracle).
As You can see I have defined *sub* *plsql_errarray* which select
error info from database and returns them in array reference much more
convinient for later use; *plsql_errstr* only converts that array into
a single string. Of course one should provide at least two additional
parameters to new plsql_errstr function.
Martin
--
Martin J. Evans
Wetherby, UK
.
[BUG FIXES]
Fixed RT 84450 - Database Handle Attribute Fetch broken. Thanks to
Stephen Oberholtzer for finding and supplying patch.
Fixed problem with attributes on bind_col not being sticky. You'll
probably only see this if you are using fetchall_arrayref with a
slice and setting TYPE or attributes in bind_col first.
Martin
Notice the "incompatible change".
I vaguely recollect this change. Does 1.618 work for you? Can you find
the code which called fetchall_arrayref and show us it as I don't use Koha.
Martin
--
Martin J. Evans
Wetherby, UK
On 23/09/2013 18:43, Nagendra Singh wrote:
Thanks Martin.
How can I get UnixODBC trace? Could you please let me know the command.
Strange thing is on one Linux machine its working fine and on another
Linux machine( Same configuration) its not.
Result of odbcinst-j is:-
UnixODBC2.2.14
Drivers
On 22/09/2013 22:41, Nagendra Singh wrote:
Hi Martin,
Thanks a bunch for looking into this problem. Here are the details asked
by you:-
PERL Version is v5.10.1
DBI Version is 1.609
DBD::ODBC version is 1.43.
Logs file are attached.
Regards,
Mr. Singh
Thank you for the trace file. Your versions
identify your problem. If this file ends up empty, try again with:
DBI_TRACE=15=x.log perl myprogram.pl
Martin
--
Martin J. Evans
Wetherby, UK
On 18/09/13 10:26, Martin J. Evans wrote:
On 18/09/13 09:58, Michael Seaton wrote:
Hi there,
I and a colleague have been trying to install Koha (an integrated
library system written in Perl) onto a server. While we've been mostly
successful in installing Koha, we keep getting the foll
ll_arrayref now detect invalid column names.
I vaguely recollect this change. Does 1.619 work for you? Can you find the code
which called fetchall_arrayref and show us it as I don't use Koha.
Martin
heck
http://cpansearch.perl.org/src/PYTHIAN/DBD-Oracle-1.66/README.help.txt
Martin
--
Martin J. Evans
Wetherby, UK
xed RT 84450 - Database Handle Attribute Fetch broken. Thanks to
Stephen Oberholtzer for finding and supplying patch.
Fixed problem with attributes on bind_col not being sticky. You'll
probably only see this if you are using fetchall_arrayref with a
slice and setting TYPE or attributes in
On 06/09/2013 17:52, Martin J. Evans wrote:
On 06/09/13 09:18, Martin J. Evans wrote:
On 05/09/13 20:28, Mike Grau wrote:
Hello,
I am completely new at this, but I am trying to read a BLOB in chunks
via ODBC in Oracle 11g using DBD::ODBC-1.43, unixODBC-2.3.1 and
oracle-instantclient11.2-odbc
On 06/09/13 09:18, Martin J. Evans wrote:
On 05/09/13 20:28, Mike Grau wrote:
Hello,
I am completely new at this, but I am trying to read a BLOB in chunks
via ODBC in Oracle 11g using DBD::ODBC-1.43, unixODBC-2.3.1 and
oracle-instantclient11.2-odbc-11.2. I can read an entire BLOB in one
read
as mistaken as DBD::Oracle DOES implement blob read
although I've not tested it works. Someone, in the distant past
attempted an implementation in DBD::ODBC but it does NOT work and is
seriously flawed."
http://www.nntp.perl.org/group/perl.dbi.dev/
.
Bear with me and I'll take another look at that code. If I cannot see anything
I might need to send you a new version with slightly different logging. By all
means nag me if I don't get back to you by tomorrow.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
lti, okay."
This is very old.
"/opt/Interwoven/TeamSite/iw-perl/lib/CORE/perl.h:380:24: error:
sys/types.h: No such file or directory"
This is a serious problem - looks like whoever installed this Perl did
not run the script to generate header files.
Martin
--
Martin J. Evans
Wetherby, UK
support is the only sure long term fix.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
u.sl <http://relclnsu.sl>
That explains some things. All the iodbc files are links to odbc and
your driver really is named with a space in it.
strace it is then - since this pretty much looks ok.
Martin
On Wed, Jun 26, 2013 at 2:01 PM, Martin J. Evans mailto:boh...@ntlworld.com>> w
On 26/06/2013 20:29, Dan Bent wrote:
I have strace, but don't know how to use it.
Usually something like:
strace -o out.log isql -v mydsn username password
then after it hangs hit ctrl/c and look at (paste here) the last 100
lines of out.log
Martin
On Wed, Jun 26, 2013 at 2:
lete. I think you need to find the equivalent of
strace on HPUX and run it on the isql command to see what system calls
are being made.
Did you say everything is on one box, so networking off that box cannot
be the issue?
Martin
On Wed, Jun 26, 2013 at 12:11 PM, Martin J. Evans mailto:bo
B2INSTANCE. SO also check any profile files for the user doing ODBC.
But if you answer the other questions in my other reply I might be able
to help more.
Martin
On Wed, Jun 26, 2013 at 11:46 AM, Jonathan Leffler
mailto:jonathan.leff...@gmail.com>> wrote:
On Wed, Jun 26, 2013
e done that if the answer is libodbc.so.something then you are
probably using the unixODBC driver manager. In that case you should
hopefully have an isql binary and you should have an odbc.ini and
odbcinst.ini defining your drivers and DSNs. What is in those files. Can
you run:
isql -v TEST1 username password
isql -v TRAIN1 username password
isql -v PROD1 username password
as you didn't say which one you are using?
If you get back with this info I'll help more.
Martin
--
Martin J. Evans
Wetherby, UK
aware
from Oracle that says they cannot change the Oracle client libs so you
could hit some incompatibility if you don't recompile.
Martin
--
Martin J. Evans
Wetherby, UK
On 24/05/13 06:51, Gabor Szabo wrote:
Hi,
On Wed, May 22, 2013 at 10:08 PM, Martin J. Evans wrote:
Another good tutorial - please keep up the good work of promoting Perl.
Thanks. I hope others will also help promoting my articles and interviews.
"The DSN (Data Source Name) (in the
d for select stmts and
especially multiple stmts in the same SQL e.g., do(q/something; select
something from something/);
Martin
--
Martin J. Evans
Wetherby, UK
a C compiler with another compiler.
Martin
--
Martin J. Evans
Wetherby, UK
I'll find some time to update the pod.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
atabases so far have complained about
this until we ran the test against Derby. Changed to use '100'.
RT 80446 - fix spelling mistake - thanks to Xavier Guimar.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
1 - 100 of 1135 matches
Mail list logo
