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 

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

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 h.m.br...@xs4all.nl wrote: On Wed, 31 Dec 2014 16:58:02 +0100, H.Merijn Brand h.m.br...@xs4all.nl 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

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 h.m.br...@xs4all.nl 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

Re: DBD::Oracle 1.72 fail

2014-05-22 Thread H.Merijn Brand
On Wed, 21 May 2014 17:28:53 -0700, Christopher Jones christopher.jo...@oracle.com wrote: On 05/19/2014 01:48 PM, H.Merijn Brand wrote: On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones christopher.jo...@oracle.com wrote: I appreciate the wealth of information. It really does

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 christopher.jo...@oracle.com wrote: On 05/19/2014 01:48 PM, H.Merijn Brand wrote: On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones christopher.jo...@oracle.com wrote: I appreciate the

Re: DBD::Oracle 1.72 fail

2014-05-22 Thread H.Merijn Brand
On Thu, 22 May 2014 07:49:15 -0700, Christopher Jones christopher.jo...@oracle.com wrote: On 5/21/14, 11:03 PM, H.Merijn Brand wrote: On Wed, 21 May 2014 17:28:53 -0700, Christopher Jones christopher.jo...@oracle.com wrote: On 05/19/2014 01:48 PM, H.Merijn Brand wrote: On Thu, 17

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 christopher.jo...@oracle.com 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

Re: DBD::Oracle 1.72 fail

2014-05-19 Thread H.Merijn Brand
On Thu, 17 Apr 2014 23:49:24 -0700, Christopher Jones christopher.jo...@oracle.com 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.

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

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 h.m.br...@xs4all.nl 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

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 :

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread H.Merijn Brand
On Tue, 15 Apr 2014 11:06:47 -0400, Yanick Champoux champ...@pythian.com 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

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

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

Re: DBD::Oracle 1.72 fail

2014-04-15 Thread H.Merijn Brand
On Tue, 15 Apr 2014 10:33:19 -0700, Christopher Jones christopher.jo...@oracle.com 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 :(

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 christopher.jo...@oracle.com 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$

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

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

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

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

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

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

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 martin.ev...@easysoft.com 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

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 h.m.br...@xs4all.nl wrote: On Sun, 24 Jun 2012 11:25:00 +0100, Martin J. Evans martin.ev...@easysoft.com 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

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 martin.ev...@easysoft.com 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

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 Yanick Champoux
On 12-03-11 11:48 AM, H.Merijn Brand wrote: On Sun, 11 Mar 2012 11:27:44 -0400, Yanick Champoux yan...@babyl.dyndns.org 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,

Re: DBD-Oracle 1.40

2012-03-12 Thread H.Merijn Brand
On Mon, 12 Mar 2012 16:02:46 -0400, Yanick Champoux yan...@babyl.dyndns.org wrote: On 12-03-11 11:48 AM, H.Merijn Brand wrote: On Sun, 11 Mar 2012 11:27:44 -0400, Yanick Champoux yan...@babyl.dyndns.org wrote: On 12-03-11 06:01 AM, H.Merijn Brand wrote: t/rt74753-utf8-encoded.t

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

Re: DBD-Oracle 1.40

2012-03-11 Thread H.Merijn Brand
On Sun, 11 Mar 2012 11:27:44 -0400, Yanick Champoux yan...@babyl.dyndns.org 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

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 champ...@pythian.com 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

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 champ...@pythian.com wrote: On 02/27/12 02:02, H.Merijn Brand wrote: On Fri, 24 Feb 2012 16:50:37 -0500, Yanick Champoux champ...@pythian.com wrote: [OTHERS] - change the shebang line of examples to the more modern '/usr/bin/env

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 v1.39_00 is out

2012-02-26 Thread H.Merijn Brand
On Fri, 24 Feb 2012 16:50:37 -0500, Yanick Champoux champ...@pythian.com 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

Re: DBD::Oracle

2012-02-11 Thread Aaron Crane
Yanick Champoux yanick.champ...@gmail.com 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

Re: DBD::Oracle

2012-02-10 Thread H.Merijn Brand
On Fri, 10 Feb 2012 14:30:03 +, Charles Jardine c...@cam.ac.uk 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 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 1;),

Re: DBD::Oracle

2012-02-10 Thread H.Merijn Brand
On Fri, 10 Feb 2012 09:56:59 -0500, Yanick Champoux yanick.champ...@gmail.com 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

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

Re: DBD::Oracle

2012-02-10 Thread H.Merijn Brand
On Fri, 10 Feb 2012 10:22:20 -0500, Yanick Champoux yanick.champ...@gmail.com 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

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 c...@cam.ac.uk 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 07:03:09PM +0100, H.Merijn Brand wrote: On Fri, 10 Feb 2012 17:28:11 +, Charles Jardine c...@cam.ac.uk 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 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 champ...@pythian.com 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

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 h.m.br...@xs4all.nl 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

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 martin.ev...@easysoft.com 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 a

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 h.m.br...@xs4all.nl 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

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 h.m.br...@xs4all.nl 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

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 Scolessco...@pythian.com 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 a

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 a href=http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip;DBD-Oracle-1.28-RC1.zip/A This is a long overdue maintenance release

Re: DBD::Oracle Release Candidate 1

2011-02-16 Thread H.Merijn Brand
On Fri, 11 Feb 2011 13:43:34 -0500, John Scoles sco...@pythian.com 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 a

Re: DBD::Oracle Release Candidate 1

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

Re: DBD::Oracle Release Candidate 1

2011-02-16 Thread John Scoles
On Wed, Feb 16, 2011 at 5:45 AM, Martin J. Evans martin.ev...@easysoft.com 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 a

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 as

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

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 why this

Re: DBD::Oracle - credentials

2011-01-14 Thread H.Merijn Brand
On Fri, 14 Jan 2011 14:56:46 +, Martin J. Evans martin.ev...@easysoft.com 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

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 martin.ev...@easysoft.com 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 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 martin.ev...@easysoft.com 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

Re: DBD::Oracle - credentials

2011-01-14 Thread H.Merijn Brand
On Fri, 14 Jan 2011 15:21:39 +, Martin J. Evans martin.ev...@easysoft.com wrote: On 14/01/11 15:01, H.Merijn Brand wrote: On Fri, 14 Jan 2011 14:56:46 +, Martin J. Evans martin.ev...@easysoft.com wrote: On 14/01/11 14:30, H.Merijn Brand wrote: Maybe this is a feature request,

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

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 t...@samasher.com wrote: Hi, We

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 jpz-p...@adelton.comwrote: Hello, The DBD::Oracle

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

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

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

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: ORA-00932:

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 c...@cam.ac.uk 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 (select

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 h.m.br...@xs4all.nl 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

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

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 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 sco...@pythian.com wrote: Ok I guess it is back to square 1 on this. Unfortunetly no time to look at

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 in that

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 For 11g users

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: 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
On Tue, Apr 6, 2010 at 4:51 AM, Martin Evans martin.ev...@easysoft.comwrote: 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

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
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

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-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. The

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,

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

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-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

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 internally.

Re: DBD-Oracle-1.23 Makefile.PL patch

2009-11-27 Thread H.Merijn Brand
On Fri, 27 Nov 2009 10:21:05 -0400, Ralph Doncaster ralphdoncas...@gmail.com wrote: It seems I can't post attachments to the list, so here's the patch inline: Looks sane to me, but I'm not the DBD::Oracle maintainer :) While you're at it, I'd like to see some more changes: * make

Re: DBD-Oracle-1.23 Makefile.PL patch

2009-11-27 Thread Ralph Doncaster
On 11/27/09, H.Merijn Brand h.m.br...@xs4all.nl wrote: On Fri, 27 Nov 2009 10:21:05 -0400, Ralph Doncaster ralphdoncas...@gmail.com wrote: While you're at it, I'd like to see some more changes: * make /usr/share/oracle not hardcoded but variable We're running Oracle perl on a few Unix boxes

Re: DBD-Oracle-1.23 Makefile.PL patch

2009-11-27 Thread H.Merijn Brand
On Fri, 27 Nov 2009 10:41:19 -0400, Ralph Doncaster ralphdoncas...@gmail.com wrote: On 11/27/09, H.Merijn Brand h.m.br...@xs4all.nl wrote: On Fri, 27 Nov 2009 10:21:05 -0400, Ralph Doncaster ralphdoncas...@gmail.com wrote: While you're at it, I'd like to see some more changes: * make

Re: DBD-Oracle-1.23 Makefile.PL patch

2009-11-27 Thread John Scoles
Of you could give it a try on 64 bit power solaris it you want to tug all of your hair out. H.Merijn Brand wrote: On Fri, 27 Nov 2009 10:41:19 -0400, Ralph Doncaster ralphdoncas...@gmail.com wrote: On 11/27/09, H.Merijn Brand h.m.br...@xs4all.nl wrote: On Fri, 27 Nov 2009 10:21:05

Re: DBD-Oracle-1.23 Makefile.PL patch

2009-11-27 Thread H.Merijn Brand
On Fri, 27 Nov 2009 10:17:01 -0500, John Scoles sco...@pythian.com wrote: Of you could give it a try on 64 bit power solaris it you want to tug all of your hair out. Would that be just as bad as True64? I feel your pain however. H.Merijn Brand wrote: On Fri, 27 Nov 2009 10:41:19 -0400,

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

2009-11-27 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 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

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

2009-11-27 Thread Martin J. Evans
Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 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

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.

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

2009-11-24 Thread Tim Bunce
I'm sorry for the delay in replying Martin. On Tue, Nov 10, 2009 at 03:24:33PM +, Martin Evans wrote: Perhaps it could have been one of those informationals as the sv is unchanged and still usable but it is not in the requested format so I'd class that an error. Perhaps we should

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

2009-11-10 Thread Martin Evans
Thread is getting a bit long so I've snipped a lot of previous code. Tim Bunce wrote: On Mon, Nov 09, 2009 at 05:05:11PM +, Martin Evans wrote: Martin Evans wrote: first patch snipped There was an omission in my addition to Tim's example as I forgot to change DBISTATE_VERSION.

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

2009-11-09 Thread Martin Evans
Tim Bunce wrote: On Tue, Oct 27, 2009 at 02:54:43PM +, Martin Evans wrote: The next question is whether overflowing to an NV should be an error. I'm thinking we could adopt these semantics for bind_col types: SQL_INTEGER IV or UV via sv_2iv(sv) with error on overflow this would be

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

2009-11-09 Thread Tim Bunce
On Mon, Nov 09, 2009 at 02:43:28PM +, Martin Evans wrote: I'm presuming you missed a bit off your patch: Yes, sorry, I was just throwing it out there for discussion of the general approach/principles. None so far. Tim.

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

2009-11-09 Thread Tim Bunce
On Mon, Nov 09, 2009 at 05:05:11PM +, Martin Evans wrote: Martin Evans wrote: +/* Convert a simple string representation of a value into a more specific + * perl type based on an sql_type value. + * The semantics of SQL standard TYPE values are interpreted _very_ loosely + * on

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

2009-10-28 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 I cannot say why you changed DBD::Pg for JSON::XS but I can say why I want integers back from Oracle instead of strings when I ask for integers and the column is an integer. I don't think it is square pegs into round holes. Well you'll

  1   2   3   >