Re: select decimal column from mysql

2021-12-19 Thread john miky
sorry, please ignore this stupid question, 0.015 is > 0 On Mon, Dec 20, 2021 at 2:19 PM john miky wrote: > hmm. it is perl's "problem", not dbi. > > On Mon, Dec 20, 2021 at 1:20 PM john miky wrote: > >> hi, >> >> I select a decimal column, from mys

Re: select decimal column from mysql

2021-12-19 Thread john miky
hmm. it is perl's "problem", not dbi. On Mon, Dec 20, 2021 at 1:20 PM john miky wrote: > hi, > > I select a decimal column, from mysql with dbi, > the value 0.015 for example, my ($v) = $dbh->selectrow_array("select > price from test limit 1") >

select decimal column from mysql

2021-12-19 Thread john miky
hi, I select a decimal column, from mysql with dbi, the value 0.015 for example, my ($v) = $dbh->selectrow_array("select price from test limit 1") it is greater than 0 in perl. What's the proper way to get a float value ?

Re: DBD error

2020-07-20 Thread John D Groenveld
In message , Bala GANESH writes: >ld: 0711-736 ERROR: Input file /oracle/product/19.7/lib/libclntsh.so: >XCOFF64 object files are not allowed in 32-bit mode. $ file `which perl` $ file /oracle/product/19.7/lib/libclntsh.so John groenv...@acm.org

AIX (xlc) DBD::Oracle *without* LIBPATH?

2019-07-26 Thread John Wiersba via dbi-users
var  or PATH (Windows) and or NLS settings, permissions, etc. at -e line 30 connection error: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var  or PATH (Windows) and or NLS settings, permissions, etc. I can provide more details if someone thinks it's possible. Thanks!-- John

Re: Translate between DBI and SQL

2019-02-08 Thread John Scoles
Well not really much DBI can do for you. You usually start from scratch trying to write SQL that is not Driver Specific though that can be hard. you are usually stuck with something like this sub edit_sql { my ($self, $sql) = @_;​ ​ if ($self->isPostgres) {​ return

Re: Tim Bunce - RE: DBD-DBI Insert Binary Files and using Perl modules in cPanel environment

2018-09-28 Thread John Scoles
I would agree MySQL my not be the platform you want. It is limited in what it can do. I would give Postgress SQL a go. You have the use the 'pg_lo_???' functions to manipulate your objects. They work quite well. By the way saving images, mp3 etc as blobs or lobs to a DB is not used in

Re: (Fwd) Perl with Oracle 12c

2018-04-11 Thread John D Groenveld
In message <2ceb8fe815e746e480d13c6cc8be3...@uscpmb01.photomask.com>, "Seidler, Reinhard" writes: >Thanks to all. Who could know the compiled Oracle client version? $ perl -MDBD::Oracle -le 'print DBD::Oracle::ORA_OCI' 12.2.0.1 >11.2 would be fine and certified by Oracle

Re: (Fwd) Perl with Oracle 12c

2018-04-10 Thread John D Groenveld
>d we deal with that? Any > answer would be appreciated. Relinking DBD::Oracle against InstantClient 12.2 is probably not required but something I would do. John groenv...@acm.org

Re: Hello Perl Comminity from ATL

2018-03-22 Thread John D Groenveld
In message <02db01d3c043$75a0ca50$60e25ef0$@gmail.com>, "Philip" writes: >Any clues on how to troubleshoot ? Crawl before you run. Create a small test script on your RT webserver and confirm you can connect to your database. <URL:https://metacpan.org/pod/DBI> John groenv...@acm.org

Re: Hunting down (possible) memory leak in DBD::Oracle

2017-12-19 Thread John Scoles
here. If could be running out of buffer. Give some of the caching params a tweak https://metacpan.org/pod/DBD::Oracle#RowCacheSize if you can try give fetchrow_hashref a try as see if the error happens there as well. Cheers John DBD::Oracle - Oracle database driver for the DBI module

Re: Hunting down (possible) memory leak in DBD::Oracle

2017-12-18 Thread John Scoles
? Lob and blob and large varchars can be tricky 4) does the error happen in perl or XS (the 15 trace should) 5) To recompile you will need the latest version of the OCI client. Not sure what that is Cheers John From: Fennell, Brian <fenne...@radial.com>

Re: Perl DBI libraries for connecting 12c

2017-10-10 Thread John D Groenveld
ent but only serves 12.1 IPS packages for Solaris 11? <URL:http://pkg.oracle.com/solaris/release/manifest/0/database%2Foracle%2Finstantclient@12.1.0.2.0%2C5.11-3%3A20150720T213959Z> >(This may not help Michael, who is using an older version of Solaris) Nope. John groenv...@acm.org

Re: Perl DBI libraries for connecting 12c

2017-10-09 Thread John R Pierce
. You do need to have the oracle client libraries and headers (which you have to get from Oracle). or you could install the perl from sunfreeware/unix packages or opencsw. -- john r pierce, recycling bits in santa cruz

Re: Perl DBI libraries for connecting 12c

2017-10-09 Thread John R Pierce
I'm confusing this with Pro*C, something else our old stack required. -- john r pierce, recycling bits in santa cruz

Re: DBD for SQL Server

2016-09-08 Thread John Adams
I've never loved unixODBC. I'd go a long way to avoid it if I didn't _have_ to use it. On Wed, Sep 7, 2016 at 9:04 AM, Peter Hircock via dbi-users < dbi-users@perl.org> wrote: > DBD::ODBC > > On Linux you can use FreeTDS & unixODBC , or Microsoft also has > Microsoft ODBC Driver for SQL Server

Re: ORA-12154 - (DBD: login failed)

2016-08-11 Thread John D Groenveld
E work against your listeners and instances. But did you confirm that you rebuilt your DBD::Oracle against your new ORACLE_HOME? $ find /u01/home/oracle/admin/site/lib/perl -name Oracle.so \ -exec ldd {} \; John groenv...@acm.org

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread John D Groenveld
've confirmed Oracle's tools in your new ORACLE_HOME can connect to your instances, I doubt you rebuilt DBD::Oracle when you changed ORACLE_HOME. John groenv...@acm.org

Re: Bundle::DBI and DBD::Oracle failing

2016-06-23 Thread John D Groenveld
racle.so? # file /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so What does ldd(1) report about missing dependencies? # ldd /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so Are the dependencies installed? Can you find(1) them? John groenv...@acm.org

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread John R Pierce
On 6/22/2016 2:05 PM, Bruce Johnson wrote: On Jun 22, 2016, at 1:34 PM, John R Pierce <pie...@hogranch.com <mailto:pie...@hogranch.com>> wrote: if root installed it to /root, no other user can see or access that. running cpan as root is fine, since that doesn’t affect the

Re: Bundle::DBI and DBD::Oracle failing

2016-06-22 Thread John R Pierce
that. the Oracle user account that wants to run the perl scripts should instead be the ones to run CPAN. and no way no how you should be doing Oracle database work while logged on as the unix root user. -- john r pierce, recycling bits in santa cruz

RE: DBI Utility Functions - more documentation?

2016-04-18 Thread John Martel
help me organize the data and get it out more efficiently. Thanks for responding. John -Original Message- From: tim.bu...@pobox.com [mailto:tim.bu...@pobox.com] Sent: Sunday, April 17, 2016 4:41 PM To: John Martel Cc: tim.bu...@pobox.com; dbi-users@perl.org Subject: Re: DBI Utility

Re: Fwd: Need support for Perl::DBD::mysql

2015-12-22 Thread John R Pierce
parameters. it would also be useful to see the command line you use to successfully connect to this database at the command prompt. -- john r pierce, recycling bits in santa cruz

Re: Data sources

2015-11-02 Thread John R Pierce
bit version, so only 32 bit applications using ODBC can read Access .mdb files. -- john r pierce, recycling bits in santa cruz

Re: /bin/sh: cc_r: not found

2015-10-29 Thread John R Pierce
ble to compile perl extensions with GCC, it likely requires jumping through hoops as the compiler options are /very/ different. -- john r pierce, recycling bits in santa cruz

Re: /bin/sh: cc_r: not found

2015-10-29 Thread John R Pierce
the software installed at all. cc_r is the multithreaded version of the cc command from XLC ... perl is built with multithreading, so... -- john r pierce, recycling bits in santa cruz

Re: make test fails installing DBI-1.632 (linux, perl5.8.8)

2015-01-08 Thread John Wiersba
And then there's the matter of the other two bugs (the incorrect warning about LANG and the =encoding thing). On Thu, Jan 8, 2015 at 12:05 PM, Furst, Carl carl.fu...@mlb.com wrote: Yeah, I agree, it would save time if there was a check during make test itself and a die with a version

Fwd: make test fails installing DBI-1.632 (linux, perl5.8.8)

2015-01-08 Thread John Wiersba
Adding dbi-users -- Forwarded message -- From: John Wiersba jrw32...@gmail.com Date: Thu, Jan 8, 2015 at 11:19 AM Subject: Re: make test fails installing DBI-1.632 (linux, perl5.8.8) To: Furst, Carl carl.fu...@mlb.com Thanks, Carl. Well, I see that now, but I did not see

Re: make test fails installing DBI-1.632 (linux, perl5.8.8)

2015-01-08 Thread John Wiersba
...@pobox.com wrote: On Wed, Jan 07, 2015 at 04:50:52PM -0500, John Wiersba wrote: I see in META.{json,yaml} that a later version of Test::Simple is required, but that doesn't seem to cause a noticable error message or abort the Makefile.PL/make/make test process. Installing the latest version

make test fails installing DBI-1.632 (linux, perl5.8.8)

2015-01-07 Thread John Wiersba
allows make test to succeed. jrw $ grep Simple META* META.json:Test::Simple : 0.90 META.yml: Test::Simple: '0.90' Let me know if you need more information. Thanks! -- John Wiersba

Re: unable to locate DBI.pm

2014-05-20 Thread John R Pierce
. -- john r pierce 37N 122W somewhere on the middle of the left coast

Re: CPAN DBI make make test error

2014-04-03 Thread John R Pierce
) Version: 11.01..0006 Do note, IBM XLC and/or XLCPP are licensed on a named user basis. At my work, only two of us have licenses to use it. -- john r pierce 37N 122W somewhere on the middle of the left coast

Re: I have a weird issue with a script running under cron

2014-02-20 Thread John D Groenveld
script when it changes. John groenv...@acm.org

Re: I have a weird issue with a script running under cron

2014-02-19 Thread John D Groenveld
that that use MODULE imports MODULE before you set the environment. John groenv...@acm.org

Re: I have a weird issue with a script running under cron

2014-02-18 Thread John D Groenveld
://news.gmane.org/find-root.php?message_id=201310221200.r9MC0w2D010081%40elvis.arl.psu.edu John groenv...@acm.org

Re: I have a weird issue with a script running under cron

2014-02-18 Thread John D Groenveld
-disconnect; $ /bin/env -i /tmp/test.sh John groenv...@acm.org

Re: I have a weird issue with a script running under cron

2014-02-17 Thread John D Groenveld
which libraries aren't resolving would be a useful test: #!/bin/ksh /bin/env - /usr/bin/ldd /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so John groenv...@acm.org

RE: Surprising DBD::Oracle error raised

2014-02-05 Thread John Scoles
way is to fetch is in a loop with 'while'. As there is no way to tell how many records will be in your set before you do you SQL unless you tell the SQL to return only x rows. Cheers John Date: Tue, 4 Feb 2014 13:36:50 -0600 Subject: Surprising DBD::Oracle error raised From: davidni

RE: Surprising DBD::Oracle error raised

2014-02-05 Thread John Scoles
Well isn't he is calling with the alias 'fetch' and he is calling it in I think scalar context my ($row) = $s-fetchrow_array; 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. Date:

Re: Surprising DBD::Oracle error raised

2014-02-05 Thread John D Groenveld
In message cafwsco-tqp5yycpptawzqkkyhz6qjs3d_g+yv5r9x9apdbm...@mail.gmail.com , David Nicol writes: the error message claimed I hadn't executed the statement. Where is your DBI_TRACE? I can't reproduce. John groenv...@acm.org use strict; use DBI; my $dbh = DBI-connect( dbi:Oracle:, scott

Re: Surprising DBD::Oracle error raised

2014-02-04 Thread John D Groenveld
, __LINE__); } I expected the fetch to return undef, but it throws an Oracle error. What does your DBI_TRACE reveal? John groenv...@acm.org

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
to get the value directly with the FETCH which works sort of, but it does bleed memory every so slighly. The latest version of DBI with the $sth-{ParamValues}, Should solve all you problems As a bonus I have another topic for me blog Cheers John Date: Wed, 29 Jan 2014 14:21

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
: hhferre...@gmail.com; boh...@ntlworld.com; dbi-users@perl.org Subject: Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE) On 31/01/14 16:21, Tim Bunce wrote: On Fri, Jan 31, 2014 at 09:11:28AM -0500, John Scoles wrote: A final note on this. Seems there was a very very

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
, Jan 31, 2014 at 12:50:36PM -0500, John Scoles wrote: Well I did do some testing. The leak was very small (1k over 10 min run) but only when one does $shift-FETCH( 'ParamValues' ), in the child callback. If it doesn't keep growing with more call then it's not a leak. Tim what would

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread John Scoles
-0500, John Scoles wrote: Well I did do some testing. The leak was very small (1k over 10 min run) but only when one does $shift-FETCH( 'ParamValues' ), in the child callback. With of course the older DBI 1.63, I did not see a leak with 1.63 no matter how long I let it run

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-24 Thread John Scoles
as that works on the Oracle side of things to limit memory. As it runs stands alone as you say it might be that the things you are binnding are not being released by perl as a referace to them may still exist. Cheers John Date: Fri, 24 Jan 2014 10:53:54 + From: boh...@ntlworld.com

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-24 Thread John Scoles
first. Martin On Fri, Jan 24, 2014 at 12:09 PM, John Scoles byter...@hotmail.com mailto:byter...@hotmail.com wrote: As Martin said that is rather old version of DBD only 3 since native exe_array was introduced 1.18, and I rember there being some leaks in early version of the native

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-24 Thread John Scoles
each time or does it change?? I susspect this my just be the int value of the callback and it would change each time you run? cheers John Date: Fri, 24 Jan 2014 14:59:25 + Subject: Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE) From: hhferre...@gmail.com To: martin.ev

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-24 Thread John Scoles
the latest DBI/DBD::Oracle is the best thing to do first. Martin On Fri, Jan 24, 2014 at 12:09 PM, John Scoles byter...@hotmail.com mailto:byter...@hotmail.com mailto:byter...@hotmail.com mailto:byter...@hotmail.com wrote: As Martin said that is rather old version of DBD only 3 since

RE: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-24 Thread John Scoles
On Fri, Jan 24, 2014 at 12:09 PM, John Scoles byter...@hotmail.com mailto:byter...@hotmail.com mailto:byter...@hotmail.com mailto:byter...@hotmail.com wrote: á á á á á á áAs Martin said that is rather old version of DBD only 3 since native exe_array was introduced 1.18, and I rember there being

Re: Build error - DBD::Oracle, Oracle 11.2.0.1, 32-bit client, remote DB

2014-01-16 Thread John D Groenveld
for -lclntsh /usr/bin/ld: cannot find -lclntsh Install the 64-bit Oracle InstantClient and set your ORACLE_HOME to it or install a 32-bit Perl and use it to build 32-bit DBD::Oracle. John groenv...@acm.org

Re: Correct pg_type for a list of columns with SELECT?

2013-11-24 Thread John R Pierce
list as a variable when preparing a statement, but apparently I'm not getting the type correct? You are not supposed to be able to do that in SQL. parameters can only be used for data values, not field names or other statement components. -- john r pierce

DBD::Informix

2013-11-12 Thread John Beranek
rows were correct; 2 rows did not get selected not ok 18 ok 19 # *** Testing of DBD::Informix complete *** # !! There appear to be problems !! Does anyone know what could be causing these failures? Is it something to worry about? Cheers, John -- John Beranek

Re: DBD::Informix test failures

2013-11-12 Thread John Beranek
On 12/11/2013 08:59, John Beranek wrote: I'm trying to compile DBD::Informix on a Linux server (or alternatively on a Solaris 10 server, but this shows the same problems) but I'm getting failures in the test suite. Firstly, I've fixed the subject, that is the subject I had initially intended

RE: Failed DBD oracle module

2013-09-24 Thread John Scoles
: john...@pharmacy.arizona.edu CC: dbi-users@perl.org Subject: Re: Failed DBD oracle module Date: Mon, 23 Sep 2013 21:09:34 + On Sep 23, 2013, at 2:02 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: This can happen if you have 32-bit oracle db installed on the system, but use

Re: DBD::Oracle installation on AIX

2013-09-13 Thread John R Pierce
On 9/12/2013 3:13 PM, Manimegalai Visvanathan wrote: export ORACLE_HOME=/app/oracle/client/jdk/jre that likely should be something more like... export ORACLE_HOME=/app/oracle/product/11.2.0.3 (Adjust to suit) -- john r pierce 37N 122W somewhere

RE: connect not connecting

2013-06-28 Thread John Scoles
is gone or you have no permission on them Find out who changed something on you Cheers John To: db...@comcast.net; dbi-users@perl.org Date: Fri, 28 Jun 2013 13:44:17 -0400 Subject: RE: connect not connecting From: eric.b...@barclays.com DBI-trace(…) might help. You should also review the docs

RE: cross database queries?

2013-06-26 Thread John Scoles
. DBI does not do the join it is the DB that does that. DBI only issues the command Cheers John Thanks, Andrew

Re: ODBC Driver failing?

2013-06-26 Thread John R Pierce
on a hunch) that this problem isn't with DBI or Perl, but with the OS level UnixODBC implementation and its configuration. Having never seen or touched an HP-UX system, I can't offer any more suggestions. -- john r pierce 37N 122W somewhere

Re: cross database queries?

2013-06-26 Thread John R Pierce
, you could maybe achieve what you want, but its almost never optimal as the planner for the 'primary' database has no way to optimize JOIN operations etc involving other databases. -- john r pierce 37N 122W somewhere on the middle of the left coast

Re: please remove me from this list

2013-06-26 Thread John R Pierce
-Unsubscribe: mailto:dbi-users-unsubscr...@perl.org List-Subscribe: mailto:dbi-users-subscr...@perl.org List-Id: dbi-users.perl.org so, sending a message to that dbi-users-unsubscr...@perl.org address will likely remove you. -- john r pierce 37N 122W

RE: (Fwd) Quick Perl Questions - DBI and DBD

2013-06-10 Thread John Scoles
It should just work as long as you did not change your Oracle client. Most of the time Oracle clients are compatible two forward and two back. Date: Mon, 10 Jun 2013 17:54:59 +0100 From: tim.bu...@pobox.com To: dbi-users@perl.org CC: douglas.e.prin...@citi.com Subject: (Fwd) Quick Perl

RE: DBD installtion 11G R2 (64Bit) 32 bit perl version

2013-05-23 Thread John Scoles
) that 32 bit client has to work on the 32 bit platform (test this with the sqlplus that come with it) 3) you will have to recompile reinstall your DBD for the 32 bit instanctclient with 'make' 4) when you run your perl make sure it uses the ORACLE_HOME of the 32 bit instant client cheers John

Re: DBI Module installtion

2013-05-01 Thread John R Pierce
the last command is 127. you don't have the IBM XLC compiler in your path. this is a commercial product ($$) and if you have it installed, its default path is generally /usr/vac/bin or /usr/vacpp/bin -- john r pierce 37N 122W somewhere on the middle

Building DBD::Oracle with one version but deploying with another

2013-04-17 Thread John Wiersba
is available), on servers with different versions of the Oracle client libraries installed? Thanks! -- John

RE: Trouble installing DBD::Oracle in OS X 10.8 ; Oracle 32 bit drivers the issue?

2012-12-17 Thread John Scoles
From: john...@pharmacy.arizona.edu Subject: Trouble installing DBD::Oracle in OS X 10.8 ; Oracle 32 bit drivers the issue? Date: Mon, 17 Dec 2012 10:15:04 -0700 To: dbi-users@perl.org So I think I've found the bad news part of my recent update 10 OS X 10.8… DBI installed just fine

RE: Perl DBI Hangs while execute()

2012-11-20 Thread John Scoles
Well I would do something like select 1 from dual rather thatn '*' It sounds like your DB coonection string is not correct. Cheers From: amaresh.poth...@gmail.com Date: Mon, 19 Nov 2012 16:59:09 +0530 Subject: Perl DBI Hangs while execute() To: dbi-users@perl.org Hi All,

Re: error: software package not installed

2012-10-16 Thread John R Pierce
://search.cpan.org/%7Ejesse/perl-5.12.1/README.solaris -- john r pierceN 37, W 122 santa cruz ca mid-left coast

RE: (Fwd) DBD::Oracle Continuous Query Notification

2012-08-29 Thread John Scoles
. Cheers John Scoles Date: Tue, 28 Aug 2012 13:06:59 +0100 From: tim.bu...@pobox.com To: dbi-users@perl.org CC: rune.hens...@trapezegroup.eu Subject: (Fwd) DBD::Oracle Continuous Query Notification - Forwarded message from Rune Henssel rune.hens...@trapezegroup.eu - Date: Tue, 28

Re: Problems installing DBI on AIX5

2012-08-03 Thread John R Pierce
product, it is not included with AIX -- john r pierceN 37, W 122 santa cruz ca mid-left coast

RE: Problems installing DBI on AIX5

2012-08-03 Thread John Scoles
the 'C' compiler and get it working like I did. Cheers John Date: Fri, 3 Aug 2012 16:43:07 +0100 From: martin.ev...@easysoft.com To: donrwalt...@gmail.com CC: dbi-users@perl.org Subject: Re: Problems installing DBI on AIX5 On 03/08/12 16:34, Don Walters

RE: Cannot connect to Oracle db; script will not run

2012-08-01 Thread John Scoles
have a look at http://search.cpan.org/~pythian/DBD-Oracle-1.46/lib/DBD/Oracle/Troubleshooting.pm it should answer most of your questions From: james.war...@acxiom.com To: beginn...@perl.org; dbi-users@perl.org CC: newbie01.p...@gmail.com;

Re: Script to test connecting to Oracle DBs

2012-07-27 Thread John D Groenveld
::Oracle linked against a modern Oracle Instant Client. Happy hacking, John groenv...@acm.org

RE: Odd error using bind_param_inout

2012-06-04 Thread John Scoles
Funny, you are right it does not look incorrect give this a quick try $csr_insert-bind_param_inout(':new_id', \my $new_resource_id, 99); Was this working before? Did it break after an upgrade or something?? cheers John From

RE: DBD::Oracle build on aix 6.1 ( host is 64 bit db server )

2012-05-20 Thread John Scoles
a web server or alike using the instant client may be what you want. In the end what do you want to do?? Cheers John To: dbi-users@perl.org From: xtdk...@gmail.com Subject: DBD::Oracle build on aix 6.1 ( host is 64 bit db server ) Date: Sat, 19 May 2012 09:27:05 -0700 The 64 bit

Unable to make DBD::Oracle 1.44

2012-04-26 Thread John Adams
rules Oracle.xs:688: warning: dereferencing type-punned pointer will break strict-aliasing rules Oracle.xsi: In function ‘boot_DBD__Oracle’: Oracle.xsi:24: warning: dereferencing type-punned pointer will break strict-aliasing rules make: *** [Oracle.o] Error 1 Can you help? Thanks, John A

Re: Unable to make DBD::Oracle 1.44

2012-04-26 Thread John Adams
Hi, Martin, On Thu, Apr 26, 2012 at 1:39 PM, Martin J. Evans martin.ev...@easysoft.com wrote: When I build against Oracle Instant Client I download the instant client from Oracle, unzip it in /home/martin. Then I set LD_LIBRARY_PATH=/home/martin/instantclient_11_2 and do perl Makefile.PL

Re: Unable to make DBD::Oracle 1.44

2012-04-26 Thread John Adams
On Thu, Apr 26, 2012 at 2:03 PM, Martin J. Evans martin.ev...@easysoft.com wrote: You are out of the problem area I've had to deal with. Well, perhaps my pain will be someone else's gain. (Or at least a warning not to do it like we're doing it now.) If you use Instant Client installed from

RE: Error I've not seen before from oracle DBD

2012-03-30 Thread John Scoles
Date: Fri, 30 Mar 2012 09:10:41 +0100 From: martin.ev...@easysoft.com To: john...@pharmacy.arizona.edu CC: dbi-users@perl.org Subject: Re: Error I've not seen before from oracle DBD On 30/03/12 09:02, Martin J. Evans wrote: On 29/03/12 22:10, Bruce Johnson wrote: On Mar 29, 2012

RE: It's a bad day here...

2012-03-30 Thread John Scoles
Are you selecting Lobs or Blobs?? Could be an issue. Crank up the ora_verbse to 15 to get everything. It would do an extra select to get any lob types. I will have to have a look at the full thread sometime tomorrow. Cheers John Subject: Re: It's a bad day here... From: john

RE: Oracle DBI on trusted hpux

2012-02-07 Thread John Scoles
I wish I could give you a 100% tumbs up on this but... It should work without problems as I have used Oracle Wallet many times before and in theory the OCI client and not the perl code should take care of all that for you. So if you can connect with DBD::Oracle it should just work. You

RE: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

2012-01-23 Thread John Scoles
I would have to agree with Martin. The bigest jump, code-wise was the jump between 16~17 so you are very much out of luck if you want to get anything fixed in 16 or eariler. I you update to 17 first and see what happens you will get a good idea if you can update any futher. I also depends on

RE: question about bind_param_inout and oracle

2012-01-05 Thread John Scoles
From: john...@pharmacy.arizona.edu Subject: question about bind_param_inout and oracle Date: Thu, 5 Jan 2012 11:37:50 -0700 To: dbi-users@perl.org In the docs there's a note that bind_param_inout_array requires a maxlen value, but that Oracle ignores this. bind_param_inout_array

RE: [DBI-Users] Fwd: Problem to get UTF8-CSV-File

2011-12-23 Thread John Scoles
Let me chime in here as well. Though I rarely ever use UTF but I beleive you can set and or override any of the ENV values this at the handle level which I think is the best solution to the orginal problem From the POD ora_charset, ora_ncharset For oracle versions = 9.2 you can specify the

Re: cannot load such file -- dbi (LoadError)

2011-12-16 Thread John R Pierce
in spite of the similarities in names. -- john r pierceN 37, W 122 santa cruz ca mid-left coast

RE: Problem with Oracle collections/objects

2011-12-13 Thread John Scoles
Well I am able to recreate it which is a good thing. Like you said about 52 iterations then it begins to gobble up memory in both oracle and perl so me think i is running out of resources. I will give it a closer look Cheers John From: byter...@hotmail.com To: martin.ev...@easysoft.com

RE: Problem with Oracle collections/objects

2011-12-13 Thread John Scoles
a little more when I get some time and see if I can rewrite the code to not use the CAST and array Cheers John From: byter...@hotmail.com To: martin.ev...@easysoft.com; dbi-...@perl.org CC: dbi-users@perl.org Subject: RE: Problem with Oracle collections/objects Date: Tue, 13 Dec 2011 06

RE: Problem with Oracle collections/objects

2011-12-11 Thread John Scoles
at something else in DBD::Oracle. Will have to load this puppy up and have a look at the verbose trace Will have to wait till monday though swamped with SlJs here today Cheers John Scoles Date: Fri, 9 Dec 2011 14:01:43 + From: martin.ev...@easysoft.com To: dbi-...@perl.org CC: dbi

RE: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-09 Thread John Scoles
I would agree with that. One thing alsot to check is to make sure the Perl that you are using is the same as the one DBD::Oracle was compiled on. Many times a use's perl could be a completed seperate path that the root perl cheers John Date: Fri, 9 Dec 2011 13:48:41 -0600 From: mn

RE: Maintaining simultaneous support for two Oracle versions in DBI

2011-12-05 Thread John Scoles
just to muck up us OCI coders. cheers John On Fri, Dec 2, 2011 at 10:27 AM, Scott Smith smi...@latfor.state.ny.uswrote: My workplace is transitioning from Oracle version 9 to version 11. I would like to build the DBD driver to support connecting to the Oracle 11 database. However, until

RE: Maintaining simultaneous support for two Oracle versions in DBI

2011-12-04 Thread John Scoles
://svn.perl.org/modules/dbd-oracle/branches/DBD-Oracle8' Renamed 8 but you can still complile it against 9 client. But before you go though that I would just get the instanct client 10 which can connect to both 9 and and 11 and that should work for you. Cheers John Date: Fri, 2 Dec 2011 13:27:09

RE: Building DBD::Oracle against Oracle full installs.

2011-11-08 Thread John Scoles
so open an RT ticket and put the patch there. I am sure Martin will apply it as soon as it is ready. Cheers John Date: Tue, 8 Nov 2011 12:55:04 + From: c...@cam.ac.uk To: byter...@hotmail.com CC: dbi-users@perl.org Subject: Re: Building DBD::Oracle against Oracle full installs

RE: Building DBD::Oracle against Oracle full installs.

2011-11-07 Thread John Scoles
to fix the problem. Hard to debug without access to the box or at least a box that looks like the one you are trying to install on. Are you using 64 bit perl? cheers John Scoles Date: Mon, 7 Nov 2011 17:15:47 + From: c...@cam.ac.uk To: dbi-users@perl.org Subject: Building DBD::Oracle

Re: Design Pattern to keep a connection opened?

2011-11-06 Thread John R Pierce
you reconnect it or you're probably leaking some memory. and I still think you should be doing this in a db-do() wrapper, whcih checks for connection related errors and does the reconnect there. you're not doing any error checking now. -- john r pierceN 37, W 122

Re: Design Pattern to keep a connection opened?

2011-11-06 Thread John R Pierce
to read, far less likely to get nailed with SQL Injection. PLUS we're catching errors. -- john r pierceN 37, W 122 santa cruz ca mid-left coast

Re: Design Pattern to keep a connection opened?

2011-11-05 Thread John R Pierce
and retries the query a reasonable number of times. -- john r pierceN 37, W 122 santa cruz ca mid-left coast

Re: Design Pattern to keep a connection opened?

2011-11-05 Thread John R Pierce
be running into timing issues. or do exactly that, only with a connection pooler like pgbouncer... -- john r pierceN 37, W 122 santa cruz ca mid-left coast

RE: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-27 Thread John Scoles
guesses on my part. Interesting concept non the less. Cheers John

RE: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-27 Thread John Scoles
dbdimp.h for the sturct imp_dbh_st) CODE: MYSomeC_Plus_Plus_method(dbh-envhp,dbh-svchp,dbh-seshp,dbh-srvhp); Myself I would write a small 'c' wrapper that would call you c++ and just a single .XS function that calls that small 'c' wrapper to fire your function. Hope this helps Cheers John

RE: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-27 Thread John Scoles
Date: Thu, 27 Oct 2011 18:42:23 +0100 From: martin.ev...@easysoft.com To: dbi-users@perl.org Subject: Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh On 27/10/2011 17:43, John Scoles wrote: Hmm!! Well yes could be done but not as part of any release of DBD

  1   2   3   4   5   6   7   8   9   10   >