Re: DBD::Oracle and RHEL8

2020-07-08 Thread H.Merijn Brand
On Mon, 6 Jul 2020 12:50:44 +0200, Oliver Dörr wrote: > Hi, > > i just tried to install DBD::Oracle 1.80 on RHEL 8 and the make > command failes. > gcc  -lpthread -shared -Wl,-z,relro -Wl,-z,now > -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -L/usr/local/lib > -fstack-protector-strong  Oracle

Re: DBD::Oracle and RHEL8

2020-07-08 Thread Christopher Jones
On 6/7/20 8:50 pm, Oliver Dörr wrote: Hi, i just tried to install DBD::Oracle 1.80 on RHEL 8 and the make command failes. gcc  -lpthread -shared -Wl,-z,relro -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -L/usr/local/lib -fstack-protector-strong  Oracle.o dbdimp.o oci8.o  -o blib/ar

Re: DBD::Oracle sometimes return wrong PRECISION

2015-01-01 Thread H.Merijn Brand
On Wed, 31 Dec 2014 18:49:24 +0100, "H.Merijn Brand" wrote: > On Wed, 31 Dec 2014 16:58:02 +0100, "H.Merijn Brand" > wrote: > > > I have something weird in DBD::Oracle (1.44 and 1.74) > > Client = 10.2.0.1.0 / AIX-5.3 - Server = 11.2.0.3.0 - 64bit / Linux > > > > consider a field that looks li

Re: DBD::Oracle sometimes return wrong PRECISION

2014-12-31 Thread H.Merijn Brand
On Wed, 31 Dec 2014 16:58:02 +0100, "H.Merijn Brand" wrote: > I have something weird in DBD::Oracle (1.44 and 1.74) > Client = 10.2.0.1.0 / AIX-5.3 - Server = 11.2.0.3.0 - 64bit / Linux > > consider a field that looks like this: > > { LINK => undef, > NAME => 'D_GE

Re: DBD::Oracle 1.72 fail

2014-05-22 Thread H.Merijn Brand
On Thu, 22 May 2014 07:49:15 -0700, Christopher Jones wrote: > On 5/21/14, 11:03 PM, H.Merijn Brand wrote: > > On Wed, 21 May 2014 17:28:53 -0700, Christopher Jones > > wrote: > > > >> > >> > >> On 05/19/2014 01:48 PM, H.Merijn Brand wrote: > >>> On Thu, 17 Apr 2014 23:49:24 -0700, Christopher J

Re: DBD::Oracle 1.72 fail

2014-05-22 Thread Christopher Jones
On 5/21/14, 11:03 PM, H.Merijn Brand wrote: On Wed, 21 May 2014 17:28:53 -0700, Christopher Jones wrote: On 05/19/2014 01:48 PM, H.Merijn Brand wrote: On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones wrote: I appreciate the wealth of information. It really does help when we have

Re: DBD::Oracle 1.72 fail

2014-05-21 Thread H.Merijn Brand
On Wed, 21 May 2014 17:28:53 -0700, Christopher Jones wrote: > > > On 05/19/2014 01:48 PM, H.Merijn Brand wrote: > > On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones > > wrote: > > > >> > >> I appreciate the wealth of information. > >> It really does help when we have to prioritize projec

Re: DBD::Oracle 1.72 fail

2014-05-21 Thread Christopher Jones
On 05/19/2014 01:48 PM, H.Merijn Brand wrote: On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones wrote: I appreciate the wealth of information. It really does help when we have to prioritize project and features. FEEDBACK! I have perl-5.18.2-ia64 running with 12c client in a 10g envir

Re: DBD::Oracle 1.72 fail

2014-05-19 Thread H.Merijn Brand
On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones wrote: > > I appreciate the wealth of information. > It really does help when we have to prioritize project and features. FEEDBACK! I have perl-5.18.2-ia64 running with 12c client in a 10g environment :) 1. Install 12c-client for HP-UX ita

Re: DBD::Oracle 1.72 fail

2014-04-17 Thread Martin J. Evans
On 15/04/2014 12:38, H.Merijn Brand wrote: Builds fail on Linux with OIC-12.1 As a side note, is anyone able to fetch Oracle Instant Client-12 for HP-UX Itanium 64 bit? Even on WinBlow$ that doesn't work :( http://www.oracle.com/technetwork/topics/hpitanium64soft-091490.html # Box 1 L

Re: DBD::Oracle 1.72 fail

2014-04-16 Thread H.Merijn Brand
On Tue, 15 Apr 2014 13:38:38 +0200, "H.Merijn Brand" wrote: > Builds fail on Linux with OIC-12.1 tl;dr; if you are not interested in porting DBD::Oracle I have now installed/gathered the available stuff for HP-UX Itanium 64bit, moved all into the required locations and tried to build DBD::Oracl

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread Christopher Jones
On 4/15/14, 10:56 AM, H.Merijn Brand wrote: On Tue, 15 Apr 2014 10:33:19 -0700, Christopher Jones wrote: On 04/15/2014 04:38 AM, H.Merijn Brand wrote: As a side note, is anyone able to fetch Oracle Instant Client-12 for HP-UX Itanium 64 bit? Even on WinBlow$ that doesn't work :( http://www

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread H.Merijn Brand
On Tue, 15 Apr 2014 10:33:19 -0700, Christopher Jones wrote: > On 04/15/2014 04:38 AM, H.Merijn Brand wrote: > > > As a side note, is anyone able to fetch Oracle Instant Client-12 for > > HP-UX Itanium 64 bit? Even on WinBlow$ that doesn't work :( > > http://www.oracle.com/technetwork/topics/hpi

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread Christopher Jones
On 04/15/2014 04:38 AM, H.Merijn Brand wrote: As a side note, is anyone able to fetch Oracle Instant Client-12 for HP-UX Itanium 64 bit? Even on WinBlow$ that doesn't work :( http://www.oracle.com/technetwork/topics/hpitanium64soft-091490.html It downloads for me: I had to log into OTN first

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread Yanick Champoux
On 2014-04-15, 11:18 AM, H.Merijn Brand wrote: Is 1.70 faring any better? Thanks, that help a lot! The culprit seems to be https://github.com/pythian/DBD-Oracle/commit/957f54750ba8c1972beabd1dcd305bd6c47c4586 I'll check with Martin, as he wrote the code and has much, much higher chances to

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread H.Merijn Brand
On Tue, 15 Apr 2014 11:06:47 -0400, Yanick Champoux wrote: > On 2014-04-15, 7:38 AM, H.Merijn Brand wrote: > > Builds fail on Linux with OIC-12.1 > > Is 1.70 faring any better? If I read the logs correctly, the problem is > > > dbdimp.h:311:27: error: âimp_dbhâ undeclared (first use in this fu

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread Yanick Champoux
On 2014-04-15, 7:38 AM, H.Merijn Brand wrote: Builds fail on Linux with OIC-12.1 Is 1.70 faring any better? If I read the logs correctly, the problem is dbdimp.h:311:27: error: âimp_dbhâ undeclared (first use in this function) ((csform==SQLCS_NCHAR) ? imp_dbh->ncharsetid : imp_dbh->charse

Re: DBD::Oracle v1.61_00 on its way to CPAN

2013-04-30 Thread Michael Portnoy
The trial version has been promoted to 1.62 (changelog below) and is now on CPAN. 1.62 2013-04-30 - promote 1.61_00 to official release Thanks to everyone who contributed to this release! Michael -- *Michael Portnoy * Software Developer Pythian love your data www.p

Re: DBD::Oracle - rt13865.t

2012-12-14 Thread Scott
On 12/14/2012 03:52 AM, Martin J. Evans wrote: On 13/12/12 17:46, Scott wrote: Do you have the DROP ANY TABLE privilege set for the userid? That is the only DROP TABLE priv I can see, so I probably need to have the dba grant it to my install-test user. I do have drop any table privilege as I

Re: DBD::Oracle - rt13865.t

2012-12-14 Thread Martin J. Evans
On 13/12/12 17:46, Scott wrote: Do you have the DROP ANY TABLE privilege set for the userid? That is the only DROP TABLE priv I can see, so I probably need to have the dba grant it to my install-test user. I do have drop any table privilege as I have the DBA role. Can't you just ignore that t

Re: DBD::Oracle - rt13865.t

2012-12-13 Thread Scott
Do you have the DROP ANY TABLE privilege set for the userid? That is the only DROP TABLE priv I can see, so I probably need to have the dba grant it to my install-test user. On 12/13/2012 11:03 AM, Martin J. Evans wrote: On 13/12/12 16:38, Scott wrote: I have to comment out the 'DROP TABLE

Re: DBD::Oracle - rt13865.t

2012-12-13 Thread Martin J. Evans
On 13/12/12 16:38, Scott wrote: I have to comment out the 'DROP TABLE' check to get this test to run. In Oracle, AFAIK, there is not a DROP TABLE privilege. If you can create it, you can drop it. Does this test not run for everyone? unless (( $priv{'CREATE TABLE'} or $priv{'CREATE A

Re: DBD::Oracle RTs a summary and request for help

2012-06-28 Thread Martin Hall
On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Oracle 10 and op gone quiet

Re: DBD::Oracle RTs a summary and request for help

2012-06-27 Thread Martin J. Evans
On 27/06/12 09:01, Martin Hall wrote: On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to

Re: DBD::Oracle RTs a summary and request for help

2012-06-27 Thread Richie
On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Oracle 10 and op gone quiet. This looks like Oracle Bug 57598

Re: DBD::Oracle RTs a summary and request for help

2012-06-26 Thread Martin J. Evans
On 26/06/2012 21:51, Richie wrote: On 6/24/2012 6:25 AM, Martin J. Evans wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Oracle 10 and op gone quiet

Re: DBD::Oracle RTs a summary and request for help

2012-06-24 Thread Martin J. Evans
On 24/06/2012 13:26, H.Merijn Brand wrote: On Sun, 24 Jun 2012 11:25:00 +0100, "Martin J. Evans" wrote: https://rt.cpan.org/Ticket/Display.html?id=69059 Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: 0712-001 Symbol OCIPing was referenced I don't have access to AIX or an Orac

Re: DBD::Oracle RTs a summary and request for help

2012-06-24 Thread H.Merijn Brand
On Sun, 24 Jun 2012 14:26:13 +0200, "H.Merijn Brand" wrote: > On Sun, 24 Jun 2012 11:25:00 +0100, "Martin J. Evans" > wrote: > > > https://rt.cpan.org/Ticket/Display.html?id=69059 > > Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: > > 0712-001 Symbol OCIPing was referenced >

Re: DBD::Oracle RTs a summary and request for help

2012-06-24 Thread H.Merijn Brand
On Sun, 24 Jun 2012 11:25:00 +0100, "Martin J. Evans" wrote: > https://rt.cpan.org/Ticket/Display.html?id=69059 > Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld: > 0712-001 Symbol OCIPing was referenced > I don't have access to AIX or an Oracle 10 and op gone quiet. I have AIX

Re: DBD::Oracle v1.45_00 on its way to CPAN

2012-06-22 Thread Yanick Champoux
On 12-06-22 12:15 PM, Jared Still wrote: Wow! Awesome effort by Martin. No kidding. He's a machine. Even possibly the answer to that age-old question: "what would be the result of downloading an OCI API to a T-800 memory dataset". Pure relentless awesomeness, that's what results. :-) Joy

Re: DBD-Oracle 1.40

2012-03-12 Thread H.Merijn Brand
On Mon, 12 Mar 2012 16:02:46 -0400, Yanick Champoux wrote: > On 12-03-11 11:48 AM, H.Merijn Brand wrote: > > On Sun, 11 Mar 2012 11:27:44 -0400, Yanick Champoux > > wrote: > > > >> On 12-03-11 06:01 AM, H.Merijn Brand wrote: > >>> t/rt74753-utf8-encoded.t (Wstat: 512 Tests: 3 Failed: 2) > >>>

Re: DBD-Oracle 1.40

2012-03-12 Thread Yanick Champoux
On 12-03-11 11:48 AM, H.Merijn Brand wrote: On Sun, 11 Mar 2012 11:27:44 -0400, Yanick Champoux wrote: On 12-03-11 06:01 AM, H.Merijn Brand wrote: t/rt74753-utf8-encoded.t (Wstat: 512 Tests: 3 Failed: 2) Failed tests: 2-3 Non-zero exit status: 2 Files=1, Tests=3, 1 wallclock secs (

Re: DBD-Oracle 1.40

2012-03-11 Thread H.Merijn Brand
On Sun, 11 Mar 2012 11:27:44 -0400, Yanick Champoux wrote: > On 12-03-11 06:01 AM, H.Merijn Brand wrote: > > t/rt74753-utf8-encoded.t (Wstat: 512 Tests: 3 Failed: 2) > >Failed tests: 2-3 > >Non-zero exit status: 2 > > Files=1, Tests=3, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.05 cusr

Re: DBD-Oracle 1.40

2012-03-11 Thread Yanick Champoux
On 12-03-11 06:01 AM, H.Merijn Brand wrote: t/rt74753-utf8-encoded.t (Wstat: 512 Tests: 3 Failed: 2) Failed tests: 2-3 Non-zero exit status: 2 Files=1, Tests=3, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.05 cusr 0.01 csys = 0.08 CPU) That's not good. I'll issue a patch Mond

Re: DBD::Oracle v1.39_00 is out

2012-02-27 Thread H.Merijn Brand
On Mon, 27 Feb 2012 09:57:33 -0500, Yanick Champoux wrote: > On 02/27/12 02:02, H.Merijn Brand wrote: > > On Fri, 24 Feb 2012 16:50:37 -0500, Yanick Champoux > > wrote: > > > > > [OTHERS] > > > - change the shebang line of examples to the more modern '/usr/bin/env > > > perl' > > > > Personal

Re: DBD::Oracle v1.39_00 is out

2012-02-27 Thread Yanick Champoux
On 02/27/12 02:02, H.Merijn Brand wrote: On Fri, 24 Feb 2012 16:50:37 -0500, Yanick Champoux wrote: >[OTHERS] >- change the shebang line of examples to the more modern '/usr/bin/env > perl' Personally I really really hate this change Fair enough. This being said, I have to poi

Re: DBD::Oracle v1.39_00 is out

2012-02-26 Thread H.Merijn Brand
On Fri, 24 Feb 2012 16:50:37 -0500, Yanick Champoux wrote: > [OTHERS] > - change the shebang line of examples to the more modern '/usr/bin/env > perl' > [RT74001] Personally I really really hate this change App::Ack was the first I noted to make this horrid change and I always revert

Re: DBD::Oracle v1.39_00 is out

2012-02-26 Thread Yanick Champoux
A new DBD::Oracle trial version is out and on its way to CPAN. It's a maintenance release with fairly minor bug fixes (full changelog below). As usual, the trial version will be soaked for 2 weeks and, pending issues, will be promoted to v1.40 for general consumption. Joy, `/anick

Re: DBD::Oracle

2012-02-11 Thread Aaron Crane
Yanick Champoux wrote: > And just to keep things interesting, I've noticed that I forgot the > ending semi-colon that is in the test. But surely that won't-- > > $ perl -E'say system "exit 1"; say system "exit 1;"' > -1 > 256 > >    --make a difference... Ah, I can explain what's going on there.

Re: DBD::Oracle

2012-02-10 Thread Tim Bunce
On Fri, Feb 10, 2012 at 07:03:09PM +0100, H.Merijn Brand wrote: > On Fri, 10 Feb 2012 17:28:11 +, Charles Jardine > wrote: > > > >> If this reproduces the problem, you have something nothing to do > > >> with databases to investigate. If it doesn't reproduce the problem, > > >> it may be that

Re: DBD::Oracle

2012-02-10 Thread H.Merijn Brand
On Fri, 10 Feb 2012 17:28:11 +, Charles Jardine wrote: > >> If this reproduces the problem, you have something nothing to do > >> with databases to investigate. If it doesn't reproduce the problem, > >> it may be that Oracle is messing with the SIGCHLD signal. > >> > >> Are you connecting dir

Re: DBD::Oracle

2012-02-10 Thread Charles Jardine
On 10/02/12 14:56, H.Merijn Brand wrote: > On Fri, 10 Feb 2012 14:30:03 +, Charles Jardine > wrote: > >> On 10/02/12 13:32, H.Merijn Brand wrote: >>> Preparing a new database machine ... >>> >>> Do I need to worry? >>> t/10general.t 1/30 >>> # Failed test 'system exit 1 should

Re: DBD::Oracle

2012-02-10 Thread Tim Bunce
On Fri, Feb 10, 2012 at 04:29:07PM +0100, H.Merijn Brand wrote: > On Fri, 10 Feb 2012 10:22:20 -0500, Yanick Champoux > wrote: > > > On 02/10/12 09:56, Yanick Champoux wrote: > > > which should be okay, but I'm suddenly thinking: on some shells > > > 'exit' might not do what we would expect

Re: DBD::Oracle

2012-02-10 Thread H.Merijn Brand
On Fri, 10 Feb 2012 10:22:20 -0500, Yanick Champoux wrote: > On 02/10/12 09:56, Yanick Champoux wrote: > > which should be okay, but I'm suddenly thinking: on some shells > > 'exit' might not do what we would expect. Indeed, I just tried: > > > > $ perl -E'say system "exit 1"' > > -1 > >

Re: DBD::Oracle

2012-02-10 Thread Yanick Champoux
On 02/10/12 09:56, Yanick Champoux wrote: which should be okay, but I'm suddenly thinking: on some shells 'exit' might not do what we would expect. Indeed, I just tried: $ perl -E'say system "exit 1"' -1 And just to keep things interesting, I've noticed that I forgot the ending semi

Re: DBD::Oracle

2012-02-10 Thread H.Merijn Brand
On Fri, 10 Feb 2012 09:56:59 -0500, Yanick Champoux wrote: > On 02/10/12 09:30, Charles Jardine wrote: > >> > t/10general.t Dubious, test returned 2 (wstat 512, 0x200) > > This symptom indicates that the system built-in function is not working. > > > > Try > > > > perl -e 'print s

Re: DBD::Oracle

2012-02-10 Thread Yanick Champoux
On 02/10/12 09:30, Charles Jardine wrote: > t/10general.t Dubious, test returned 2 (wstat 512, 0x200) This symptom indicates that the system built-in function is not working. Try perl -e 'print system("exit 1;"), "\n"' Hmmm... The test that is failing is is system("exit

Re: DBD::Oracle

2012-02-10 Thread H.Merijn Brand
On Fri, 10 Feb 2012 14:30:03 +, Charles Jardine wrote: > On 10/02/12 13:32, H.Merijn Brand wrote: > > Preparing a new database machine ... > > > > Do I need to worry? > > t/10general.t 1/30 > > # Failed test 'system exit 1 should return 256' > > # at t/10general.t line 41. >

Re: DBD::Oracle

2012-02-10 Thread Charles Jardine
On 10/02/12 13:32, H.Merijn Brand wrote: > Preparing a new database machine ... > > Do I need to worry? > t/10general.t 1/30 > # Failed test 'system exit 1 should return 256' > # at t/10general.t line 41. > # got: '-1' > # expected: '256' > > # Failed test 'system

Re: DBD::Oracle v1.32 and v1.33_00 on their way to CPAN

2011-10-21 Thread H.Merijn Brand
On Tue, 18 Oct 2011 13:15:58 -0400, Yanick Champoux wrote: > Hi all, > > As no issue has been found with DBD::Oracle v1.31_00, it has been > promoted to v1.32 and is on its way to CPAN. With a perl configured with -Duselongdouble: This is perl 5, version 14, subversion 1 (v5.14.1) built f

Re: DBD::Oracle Release Candidate 1

2011-02-18 Thread John Scoles
On 18/02/2011 4:12 AM, Charles Jardine wrote: Ok that cleans that one up.. Hopefully I will have some time today to get to that one Thanks John On 17/02/11 12:34, H.Merijn Brand wrote: On Wed, 16 Feb 2011 12:32:12 +0100, "H.Merijn Brand" wrote: http://www.pythian.com/news/wp-content/uploa

Re: DBD::Oracle Release Candidate 1

2011-02-18 Thread Charles Jardine
On 17/02/11 12:34, H.Merijn Brand wrote: On Wed, 16 Feb 2011 12:32:12 +0100, "H.Merijn Brand" wrote: http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip You need to work on longdouble support I guess I wrote the tests in question. I included object properties of type DA

Re: DBD::Oracle Release Candidate 1

2011-02-17 Thread Martin J. Evans
On 16/02/11 11:32, H.Merijn Brand wrote: On Fri, 11 Feb 2011 13:43:34 -0500, John Scoles wrote: Here is the latest and greatest DBD::Oracle for your programming pleasure. You can find the Zip file here A ZIP is a quite unusual way to release CPAN modules, even for RC's http://www.pythian.c

Re: DBD::Oracle Release Candidate 1

2011-02-17 Thread John Scoles
On 17/02/2011 7:34 AM, H.Merijn Brand wrote: On Wed, 16 Feb 2011 12:32:12 +0100, "H.Merijn Brand" wrote: http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip You need to work on longdouble support I guess Here's a patch to make the test PASS on all systems, but I'm not s

Re: DBD::Oracle Release Candidate 1

2011-02-17 Thread H.Merijn Brand
On Wed, 16 Feb 2011 12:32:12 +0100, "H.Merijn Brand" wrote: > http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip > > You need to work on longdouble support I guess Here's a patch to make the test PASS on all systems, but I'm not sure if I'm using a carpet to shuv the proble

Re: DBD::Oracle Release Candidate 1

2011-02-17 Thread Martin J. Evans
On 16/02/11 12:00, John Scoles wrote: On Wed, Feb 16, 2011 at 5:45 AM, Martin J. Evans wrote: On 11/02/11 18:43, John Scoles wrote: Here is the latest and greatest DBD::Oracle for your programming pleasure. You can find the Zip file here http://www.pythian.com/news/wp-content/uploads/DBD-O

Re: DBD::Oracle Release Candidate 1

2011-02-16 Thread John Scoles
On Wed, Feb 16, 2011 at 5:45 AM, Martin J. Evans wrote: > On 11/02/11 18:43, John Scoles wrote: >> >> Here is the latest and greatest DBD::Oracle for your programming pleasure. >> >> You can find the Zip file here >> >> > href="http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zi

Re: DBD::Oracle Release Candidate 1

2011-02-16 Thread H.Merijn Brand
On Fri, 11 Feb 2011 13:43:34 -0500, John Scoles wrote: > Here is the latest and greatest DBD::Oracle for your programming pleasure. > > You can find the Zip file here > > href="http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip";>DBD-Oracle-1.28-RC1.zip Next to the failur

Re: DBD::Oracle Release Candidate 1

2011-02-16 Thread H.Merijn Brand
On Fri, 11 Feb 2011 13:43:34 -0500, John Scoles wrote: > Here is the latest and greatest DBD::Oracle for your programming pleasure. > > You can find the Zip file here A ZIP is a quite unusual way to release CPAN modules, even for RC's > href="http://www.pythian.com/news/wp-content/uploads/DBD

Re: DBD::Oracle Release Candidate 1

2011-02-16 Thread Martin J. Evans
On 11/02/11 18:43, John Scoles wrote: Here is the latest and greatest DBD::Oracle for your programming pleasure. You can find the Zip file here http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip";>DBD-Oracle-1.28-RC1.zip This is a long overdue maintenance release that fixe

Re: DBD::Oracle - credentials

2011-01-18 Thread Tim Bunce
On Fri, Jan 14, 2011 at 04:45:52PM +0100, H.Merijn Brand wrote: > > Yes, the *DBD::Oracle* README. I know, I found it there, but I was more > looking for guides from DBI. Does DBI document that DBU_USER/DBI_PASS > would somehow overrule other (default) settings? DBI_USER and DBI_PASS are applied

Re: DBD::Oracle - credentials

2011-01-14 Thread H.Merijn Brand
On Fri, 14 Jan 2011 15:21:39 +, "Martin J. Evans" wrote: > On 14/01/11 15:01, H.Merijn Brand wrote: > > On Fri, 14 Jan 2011 14:56:46 +, "Martin J. Evans" > > wrote: > > > >> On 14/01/11 14:30, H.Merijn Brand wrote: > >>> Maybe this is a feature request, but if I have > >>> > >>> ORACL

Re: DBD::Oracle - credentials

2011-01-14 Thread John Scoles
On 14/01/2011 10:21 AM, Martin J. Evans wrote: On 14/01/11 15:01, H.Merijn Brand wrote: On Fri, 14 Jan 2011 14:56:46 +, "Martin J. Evans" wrote: On 14/01/11 14:30, H.Merijn Brand wrote: Maybe this is a feature request, but if I have ORACLE_USERID=john/sekrit DBI_USER=pablo DB

Re: DBD::Oracle - credentials

2011-01-14 Thread Martin J. Evans
On 14/01/11 15:01, H.Merijn Brand wrote: > On Fri, 14 Jan 2011 14:56:46 +, "Martin J. Evans" > wrote: > >> On 14/01/11 14:30, H.Merijn Brand wrote: >>> Maybe this is a feature request, but if I have >>> >>> ORACLE_USERID=john/sekrit >>> DBI_USER=pablo >>> DBI_PASS=neruda >>> >>> I *do*

Re: DBD::Oracle - credentials

2011-01-14 Thread H.Merijn Brand
On Fri, 14 Jan 2011 14:56:46 +, "Martin J. Evans" wrote: > On 14/01/11 14:30, H.Merijn Brand wrote: > > Maybe this is a feature request, but if I have > > > > ORACLE_USERID=john/sekrit > > DBI_USER=pablo > > DBI_PASS=neruda > > > > I *do* expect that DBD::Oracle uses DBI_USER and DBI_

Re: DBD::Oracle - credentials

2011-01-14 Thread Martin J. Evans
On 14/01/11 14:30, H.Merijn Brand wrote: > Maybe this is a feature request, but if I have > > ORACLE_USERID=john/sekrit > DBI_USER=pablo > DBI_PASS=neruda > > I *do* expect that DBD::Oracle uses DBI_USER and DBI_PASS *instead of* > the ORACLE_USERID. Anyone can come up with a good reason wh

Re: DBD::Oracle - credentials

2011-01-14 Thread John Scoles
On 14/01/2011 9:30 AM, H.Merijn Brand wrote: Maybe this is a feature request, but if I have ORACLE_USERID=john/sekrit DBI_USER=pablo DBI_PASS=neruda I *do* expect that DBD::Oracle uses DBI_USER and DBI_PASS *instead of* the ORACLE_USERID. Anyone can come up with a good reason why this

Re: DBD-Oracle stored proc with array bug

2010-12-21 Thread Tim Oertel
Built from SVN, works in our test environment. John Scoles wrote, on or about 12/18/2010 8:08 PM: Ok I got it to work 100% with the test seems you gave a little too much SP You will find it in trunk of DBD::Oracle which is here http://svn.perl.org/modules/dbd-oracle/trunk Thanks again Chee

Re: DBD-Oracle stored proc with array bug

2010-12-18 Thread John Scoles
Ok I got it to work 100% with the test seems you gave a little too much SP You will find it in trunk of DBD::Oracle which is here http://svn.perl.org/modules/dbd-oracle/trunk Thanks again Cheers John Scoles On Tue, Dec 14, 2010 at 10:39 AM, Tim Oertel wrote: > > Hi, > > We were recently tr

Re: DBD::Oracle 1.26 new_tablename / synonyms issue

2010-12-17 Thread John Scoles
I have applied this patch to trunk you can find it here http://svn.perl.org/modules/dbd-oracle/trunk It will be part of Release 1.28 sometime before the end of the month. Cheers John Scoles On Tue, Nov 16, 2010 at 10:28 AM, Jan Pazdziora wrote: > > Hello, > > The DBD::Oracle 1.26 code > >

Re: DBD-Oracle stored proc with array bug

2010-12-14 Thread Tim Oertel
Okay, I'll keep my eyes on the list, at least until then. :) John Scoles wrote, on or about 12/14/2010 12:43 PM: Ok thanks for that. At first glance this looks like it might fix another reported bug and it is doing some work for me as I wanted to add in OCIServerRelease_log for my own selfish

Re: DBD-Oracle stored proc with array bug

2010-12-14 Thread John Scoles
Ok thanks for that. At first glance this looks like it might fix another reported bug and it is doing some work for me as I wanted to add in OCIServerRelease_log for my own selfish reasons so thanks for that:) It will be going into 1.28 as 1.27 is reserved for a PERL_POLLUTE release which s

Re: DBD::Oracle 1.26 does not install with CentOS/RHEL 5.5 and OIC 11.2

2010-12-07 Thread Martin J. Evans
On 06/12/10 20:32, Alexander Farber wrote: > Hello, > > I have installed the following packages: > > oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm > oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm > oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm > > on my CentOS 5.5 Lin

Re: DBD::Oracle DRCP_1.25

2010-08-27 Thread Cliff Martin
On Jul 6, 7:36 am, sco...@pythian.com (John Scoles) wrote: > > Gee didn't know anyone else was even interested in DRCP.  good to see > there is some interest I know this post is more than a month old, but I am very excited about this. I just found that DBD::Oracle 1.2.5 was nearly ready. I have b

Re: DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes

2010-08-06 Thread H.Merijn Brand
On Fri, 06 Aug 2010 09:56:36 +0100, Charles Jardine wrote: > On 05/08/10 12:49, H.Merijn Brand wrote: > > Snip > > > $dbh->do (qq; > > create global temporary table t_foo ( > > h_key blob, > > h_value blob > > ); > > ); > > > > my $sth = $dbh->prepare

Re: DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes

2010-08-06 Thread Charles Jardine
On 05/08/10 12:49, H.Merijn Brand wrote: Snip > $dbh->do (qq; > create global temporary table t_foo ( > h_key blob, > h_value blob > ); > ); > > my $sth = $dbh->prepare ("select h_value from t_foo where h_key = ?"); > $ perl test.pl > DBD::Oracle::db prepare failed: O

Re: DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes

2010-08-05 Thread H.Merijn Brand
On Thu, 5 Aug 2010 13:49:57 +0200, "H.Merijn Brand" wrote: > my $sth = $dbh->prepare ("select h_value from t_foo where h_key = ?"); > $ perl test.pl > DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes: expected - > got BLOB (DBD ERROR: error possibly near <*> indicator at char 32

Re: DBD::Oracle DRCP_1.25

2010-07-09 Thread luben karavelov
On 9.07.2010 00:41, John Scoles wrote: Hi Luben I have incorporated your patch into the DRCP branch and I have also merged that branch back into trunk for any testing that you will be doing I would try it with the Trunk which you can find here http://svn.perl.org/modules/dbd-oracle/trunk I we

Re: DBD::Oracle DRCP_1.25

2010-07-08 Thread John Scoles
Hi Luben I have incorporated your patch into the DRCP branch and I have also merged that branch back into trunk for any testing that you will be doing I would try it with the Trunk which you can find here http://svn.perl.org/modules/dbd-oracle/trunk I went with the ORA_DRCP_* for the attribute n

Re: DBD::Oracle DRCP_1.25

2010-07-07 Thread luben karavelov
As I have promissed, here comes the documentation patch. I am not native speeker, so may be it will need an edit. Also, I have added processing of environment valiables ORA_POOL_CLASS, ORA_POOL_MIN, ORA_POOL_MAX, ORA_POOL_INCR if there is ORA_DRCP env set. Best regards luben Index: Oracle.pm ==

Re: DBD::Oracle DRCP_1.25

2010-07-06 Thread luben karavelov
On 6.07.2010 14:36, John Scoles wrote: luben wrote: Gee didn't know anyone else was even interested in DRCP. good to see there is some interest Just to let you know that branch is in the very Beta stages so expect a few things to be missing Yes, I know it is in beta. I was just intereseted.

Re: DBD::Oracle DRCP_1.25

2010-07-06 Thread John Scoles
luben wrote: Gee didn't know anyone else was even interested in DRCP. good to see there is some interest Just to let you know that branch is in the very Beta stages so expect a few things to be missing Hello, I have noticed and installed DRCP_1.25 branch from DBD::Oracle repository. It se

Re: DBD::Oracle 11gr2 & ORA-38909

2010-06-04 Thread Scott T. Hildreth
On Fri, 2010-06-04 at 16:42 -0400, John Scoles wrote: > Had a quick look at it today give it a try agian but this time make > sure you have autocommit off > > > AutoCommit=>1 This turns it on, so you want it on or off? > > on the connection method > > cheers > > On Fri, May 21, 2010 at 11:20

Re: DBD::Oracle 11gr2 & ORA-38909

2010-06-04 Thread John Scoles
Had a quick look at it today give it a try agian but this time make sure you have autocommit off AutoCommit=>1 on the connection method cheers On Fri, May 21, 2010 at 11:20 AM, John Scoles wrote: > Ok I guess it is back to square 1 on this. > > Unfortunetly no time to look at it today > > Wi

Re: DBD::Oracle 11gr2 & ORA-38909

2010-05-21 Thread John Scoles
Ok I guess it is back to square 1 on this. Unfortunetly no time to look at it today Will write up a small test script and see if my patch actually does anything You may hear from me in a few days Cheers John Scott T. Hildreth wrote: On Fri, 2010-05-21 at 09:23 +0100, Martin Evans wrote:

Re: DBD::Oracle 11gr2 & ORA-38909

2010-05-21 Thread Scott T. Hildreth
On Fri, 2010-05-21 at 09:23 +0100, Martin Evans wrote: > John Scoles wrote: > > Ok I have patched up a solution I think will work across the board and you > > can find it here > > > > http://svn.perl.org/modules/dbd-oracle/branches/oci_batch > > > > here are the details > > > > ora_oci_batch > >

Re: DBD::Oracle 11gr2 & ORA-38909

2010-05-21 Thread Martin Evans
John Scoles wrote: > Ok I have patched up a solution I think will work across the board and you > can find it here > > http://svn.perl.org/modules/dbd-oracle/branches/oci_batch > > here are the details > > ora_oci_batch > > For 11g users you may encounter an error while using the execute_array

Re: Clarification sought on private_attribute_info WAS Re: DBD::Oracle 11gr2 & ORA-38909

2010-05-10 Thread Tim Bunce
[Sorry for the delay] On the one hand, the DBI makes a distinction between "method attributes" and "handle attributes. They're different things. On the other hand, the handle constructor methods are a special case. The method attributes passed to connect() are applied to the newly created dbh as

Re: DBD::Oracle 11gr2 & ORA-38909

2010-05-07 Thread John Scoles
Ok I have patched up a solution I think will work across the board and you can find it here http://svn.perl.org/modules/dbd-oracle/branches/oci_batch here are the details ora_oci_batch For 11g users you may encounter an error while using the execute_array in that it does not return a full list

Clarification sought on private_attribute_info WAS Re: DBD::Oracle 11gr2 & ORA-38909

2010-05-07 Thread Martin Evans
Apologies for top posting but this is an old thread and I include it for reference but really I'd like some clarification from Tim as to whether the following is correct. As John states the DBI documentation says for private_attribute_info: "Returns a reference to a hash whose keys are the names

Re: DBD::Oracle 11gr2 & ORA-38909

2010-05-07 Thread John Scoles
On Tue, Apr 6, 2010 at 4:51 AM, Martin Evans wrote: > I haven't seen a reply to this yet but I've been on holiday so might > have missed it: > > Scott T. Hildreth wrote: > > On Wed, 2010-03-31 at 12:20 -0500, Scott T. Hildreth wrote: > >> We have run into an issue with array processing in 11g. Th

Re: DBD::Oracle 11gr2 & ORA-38909

2010-04-06 Thread Scott T. Hildreth
On Tue, 2010-04-06 at 09:51 +0100, Martin Evans wrote: > I haven't seen a reply to this yet but I've been on holiday so might > have missed it: > > Scott T. Hildreth wrote: > > On Wed, 2010-03-31 at 12:20 -0500, Scott T. Hildreth wrote: > >> We have run into an issue with array processing in 11g.

Re: DBD::Oracle 11gr2 & ORA-38909

2010-04-06 Thread Martin Evans
I haven't seen a reply to this yet but I've been on holiday so might have missed it: Scott T. Hildreth wrote: > On Wed, 2010-03-31 at 12:20 -0500, Scott T. Hildreth wrote: >> We have run into an issue with array processing in 11g. The developer >> was using execute_array and his sql statement had

Re: DBD::Oracle 11gr2 & ORA-38909

2010-04-02 Thread Scott T. Hildreth
On Wed, 2010-03-31 at 12:20 -0500, Scott T. Hildreth wrote: > We have run into an issue with array processing in 11g. The developer > was using execute_array and his sql statement had 'LOG ERRORS' in it. > This did not error out until we switched to 11g. The issue is that only > one is allowed, e

Re: DBD::Oracle, Support binding of integers so they are returned as IVs

2009-12-02 Thread Martin Evans
Tim Bunce wrote: > > Post a diff and I'll review it for you. The code you appended previously > looks ok. Attached is a diff for DBD::Oracle based on subversion this morning (the diffs for oci8.c may be a little difficult to read due to the large indentation of the surrounding code and there are

Re: DBD::Oracle, Support binding of integers so they are returned as IVs

2009-12-02 Thread Rudy Lippan
On 11/27/2009 01:03 PM, Greg Sabino Mullane wrote: > I'd opine that since we're dealing with databases holding Important Things, > the default should be to throw an error and make people flip a switch > to get lax mode. A large warning in the upgreade notes should suffice for > anyone tr

Re: DBD::Oracle, Support binding of integers so they are returned as IVs

2009-12-01 Thread Martin J. Evans
Apologies if it seems this change is stalled, I've been extremely busy attempting to keep the wolf from the door. I will be back on it to finish it in the next few days. I've so far: o documented change in trunk for bind_col (edited by Tim) o documented change in trunk for DBI::DBD o fixed a probl

Re: DBD::Oracle, Support binding of integers so they are returned as IVs

2009-11-28 Thread Tim Bunce
On Sat, Nov 28, 2009 at 11:05:31AM +0100, H.Merijn Brand wrote: > > > > > > Does anyone know if there are other databases that have mapping issues > > > with > > > integers and Perlish integers other than Oracle? Just curious, as I only > > > personally know how a handful deal with ints internall

Re: DBD::Oracle, Support binding of integers so they are returned as IVs

2009-11-28 Thread H.Merijn Brand
On Sat, 28 Nov 2009 00:43:48 +, Tim Bunce wrote: > On Fri, Nov 27, 2009 at 06:03:29PM -, Greg Sabino Mullane wrote: > > > > > I'm mostly settled on DBIstcf_STRICT _not_ being the default. > > > So 'loosely typed' will be the default and people who want an error > > > if the type can't be

Re: DBD::Oracle, Support binding of integers so they are returned as IVs

2009-11-27 Thread Tim Bunce
On Fri, Nov 27, 2009 at 06:03:29PM -, Greg Sabino Mullane wrote: > > > I'm mostly settled on DBIstcf_STRICT _not_ being the default. > > So 'loosely typed' will be the default and people who want an error > > if the type can't be cast safely will need to use StrictlyTyped => 1. > >

  1   2   3   >