Re: ANNOUNCE: DBD::Oracle 1.17

2006-02-14 Thread Paul G. Weiss
From the latest docs: AL16UTF16 = valid for NCHAR columns (CSID=2000) UTF8 = valid for NCHAR columns (CSID=871), deprecated AL32UTF8 = valid for NCHAR and CHAR columns (CSID=873) -and- Both UTF8 and AL32UTF32 can be used in NLS_LANG and NLS_NCHAR.

Re: ANNOUNCE: DBD::Oracle 1.17

2006-02-14 Thread Tim Bunce
On Tue, Feb 14, 2006 at 11:00:33AM -0500, Paul G. Weiss wrote: From the latest docs: AL16UTF16 = valid for NCHAR columns (CSID=2000) UTF8 = valid for NCHAR columns (CSID=871), deprecated AL32UTF8 = valid for NCHAR and CHAR columns (CSID=873) -and-

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 6

2006-02-13 Thread H.Merijn Brand
On Thu, 2 Feb 2006 20:57:02 +, Tim Bunce [EMAIL PROTECTED] wrote: On Thu, Feb 02, 2006 at 03:17:38PM +0100, H.Merijn Brand wrote: On Fri, 27 Jan 2006 23:47:41 +, Tim Bunce [EMAIL PROTECTED] wrote: Here's what I hope to announce as a release candidate on dbi-users, but before I

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 6

2006-02-13 Thread Tim Bunce
On Mon, Feb 13, 2006 at 03:33:42PM +0100, H.Merijn Brand wrote: On Thu, 2 Feb 2006 20:57:02 +, Tim Bunce [EMAIL PROTECTED] wrote: On Thu, Feb 02, 2006 at 03:17:38PM +0100, H.Merijn Brand wrote: On Fri, 27 Jan 2006 23:47:41 +, Tim Bunce [EMAIL PROTECTED] wrote: Here's what I

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 6

2006-02-13 Thread H.Merijn Brand
On Mon, 13 Feb 2006 16:45:20 +, Tim Bunce [EMAIL PROTECTED] wrote: On Mon, Feb 13, 2006 at 03:33:42PM +0100, H.Merijn Brand wrote: On Thu, 2 Feb 2006 20:57:02 +, Tim Bunce [EMAIL PROTECTED] wrote: On Thu, Feb 02, 2006 at 03:17:38PM +0100, H.Merijn Brand wrote: On Fri, 27 Jan

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 5

2006-01-20 Thread Tim Bunce
On Thu, Jan 19, 2006 at 08:12:03AM +0100, H.Merijn Brand wrote: Will the README.hpux changes be included, or do you wait for the refactoring? Doc patches can be dropped in anytime - they don't need testing. I figure there'll be at least a week of public testing of RC6 on dbi-users. Tim. p.s.

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 5

2006-01-19 Thread Tim Bunce
On Wed, Jan 18, 2006 at 11:54:36PM -, Andy Hassall wrote: Here's a hopefully-final-stake-in-the-ground: http://www.data-plan.com/public/DBD-Oracle-1.17-RC5.tar.gz There seems to be a problem with the server? Connecting to www.data-plan.com|193.195.70.8|:80... connected.

Re: Installation on .rpm Instatnt Client (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2006-01-18 Thread Tim Bunce
Thanks. I've made find_headers always return absolute paths and made the corresponding changes elsewhere. RC5 is on it's way... Tim. On Mon, Jan 16, 2006 at 02:57:21PM +0100, Honza Pazdziora wrote: On Wed, Jan 11, 2006 at 10:22:18AM +, Tim Bunce wrote: Running

ANNOUNCE: DBD::Oracle 1.17 release candidate 5

2006-01-18 Thread Tim Bunce
Here's a hopefully-final-stake-in-the-ground: http://www.data-plan.com/public/DBD-Oracle-1.17-RC5.tar.gz As usual I'd be grateful for more, and wider, testing. (Please send reports of success just to me, not the list, to reduce the noise level for the long-suffering non-Oracle people here.)

RE: ANNOUNCE: DBD::Oracle 1.17 release candidate 5

2006-01-18 Thread Andy Hassall
Here's a hopefully-final-stake-in-the-ground: http://www.data-plan.com/public/DBD-Oracle-1.17-RC5.tar.gz There seems to be a problem with the server? [EMAIL PROTECTED] ~/src $ wget http://www.data-plan.com/public/DBD-Oracle-1.17-RC5.tar.gz --23:48:53--

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 5

2006-01-18 Thread H.Merijn Brand
On Wed, 18 Jan 2006 11:29:10 +, Tim Bunce [EMAIL PROTECTED] wrote: Here's a hopefully-final-stake-in-the-ground: http://www.data-plan.com/public/DBD-Oracle-1.17-RC5.tar.gz As usual I'd be grateful for more, and wider, testing. (Please send reports of success just to me, not the

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-17 Thread Tim Bunce
On Tue, Jan 17, 2006 at 10:06:36AM +0100, H.Merijn Brand wrote: I also suggest to make a new sub-folder with the examples of all the config.sh's, perl -V lists and Makefiles as separate files. Not only that makes it easier to copy/alter these files for personal use, but also shortens the

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-17 Thread Tim Bunce
On Tue, Jan 17, 2006 at 12:00:31PM +0100, H.Merijn Brand wrote: On Tue, 17 Jan 2006 09:54:53 +, Tim Bunce [EMAIL PROTECTED] wrote: On Tue, Jan 17, 2006 at 10:06:36AM +0100, H.Merijn Brand wrote: I also suggest to make a new sub-folder with the examples of all the config.sh's,

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-17 Thread H.Merijn Brand
On Tue, 17 Jan 2006 17:10:29 +, Tim Bunce [EMAIL PROTECTED] wrote: On Tue, Jan 17, 2006 at 12:00:31PM +0100, H.Merijn Brand wrote: On Tue, 17 Jan 2006 09:54:53 +, Tim Bunce [EMAIL PROTECTED] wrote: On Tue, Jan 17, 2006 at 10:06:36AM +0100, H.Merijn Brand wrote: I also

Re: Truncation on single byte to UTF-8 conversion (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2006-01-16 Thread Honza Pazdziora
On Mon, Jan 09, 2006 at 03:19:13PM +, Tim Bunce wrote: Any idea what should I try next to make CS_IS_UTF8 (and fbh-csid) behave like it is supposed to? Try the appended patch. Should work for NCHAR as well. Thanks Honza. Tim. Index: oci8.c

Re: Installation on .rpm Instatnt Client (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2006-01-16 Thread Honza Pazdziora
On Wed, Jan 11, 2006 at 10:22:18AM +, Tim Bunce wrote: Running ORACLE_HOME=/usr/lib/oracle/10.2.0.1/client/lib perl Makefile.PL -m /usr/share/oracle/10.2.0.1/client/demo.mk seems to go well for the Makefile.PL, but make is not able to find the header files. So it seems

RE: ANNOUNCE: DBD::Oracle 1.17 release candidate 4

2006-01-15 Thread Andy Hassall
Here's another stake-in-the-ground so we know where we're at: http://www.data-plan.com/public/DBD-Oracle-1.17-RC4.tar.gz Test results for RC4 here: http://www.andyh.co.uk/temp/DBD-Oracle/1.17RC4/ Just Linux and native Windows on there - all the combinations from last time, plus

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-13 Thread Charles Jardine
Andy Hassall wrote: What seems to be happening with RC3 is that Makefile.PL is behaving as if I had a full Oracle install rather than an Instant Client. Yeap. I'll take a closer look at the log and see if I can spot why. Thanks for the details. I think it just needs the Oracle XE and Oracle

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate

2006-01-13 Thread Tim Bunce
On Thu, Jan 12, 2006 at 10:42:36PM -, Andy Hassall wrote: Looking at the logs again it seems the picture isn't too bad... Note that the NLS_LANG=.AL32UTF8 tests pass. That's the config you ought to use. See the Unicode section in the DBD::Oracle docs for why Oracle's UTF8

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate

2006-01-13 Thread John Scoles
13, 2006 4:49 AM Subject: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate On Thu, Jan 12, 2006 at 10:42:36PM -, Andy Hassall wrote: Looking at the logs again it seems the picture isn't too bad... Note that the NLS_LANG=.AL32UTF8 tests pass. That's the config you ought to use

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-12 Thread H.Merijn Brand
On Wed, 11 Jan 2006 23:57:58 +, Tim Bunce [EMAIL PROTECTED] wrote: http://www.data-plan.com/public/DBD-Oracle-1.17-RC3.tar.gz We're getting there. This one fixes the two issues raised against RC2 (thanks Andy and Steffen). HP-UX 11.23, perl-5.8.7-dor/64, DBI 1.50, HP C-ANSI-C,

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-12 Thread Charles Jardine
Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17-RC3.tar.gz We're getting there. This one fixes the two issues raised against RC2 (thanks Andy and Steffen). I'd be grateful for more, and wider, testing. Thanks! Neither this release, nor RC2, work against the Instant

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-12 Thread Charles Jardine
Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17-RC3.tar.gz We're getting there. This one fixes the two issues raised against RC2 (thanks Andy and Steffen). I'd be grateful for more, and wider, testing. Thanks! Neither this release, nor RC2, work against the Instant

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-12 Thread Tim Bunce
On Thu, Jan 12, 2006 at 11:02:46AM +0100, H.Merijn Brand wrote: On Wed, 11 Jan 2006 23:57:58 +, Tim Bunce [EMAIL PROTECTED] wrote: http://www.data-plan.com/public/DBD-Oracle-1.17-RC3.tar.gz We're getting there. This one fixes the two issues raised against RC2 (thanks Andy and

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate

2006-01-12 Thread Tim Bunce
Looking at the logs again it seems the picture isn't too bad... Note that the NLS_LANG=.AL32UTF8 tests pass. That's the config you ought to use. See the Unicode section in the DBD::Oracle docs for why Oracle's UTF8 character set is broken and AL32UTF8 should be used instead. For the

Re: Installation on .rpm Instatnt Client (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2006-01-11 Thread Tim Bunce
On Thu, Dec 29, 2005 at 12:11:50PM +0100, Honza Pazdziora wrote: On Wed, Dec 28, 2005 at 11:11:31PM +, Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17.tar.gz =head1 Changes in DBD-Oracle 1.17 (svn rev 2334) [...] Changed Binding Cursors docs, clarifying

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate

2006-01-11 Thread Tim Bunce
On Tue, Jan 10, 2006 at 10:15:36PM +, Tim Bunce wrote: On Sun, Jan 01, 2006 at 11:39:17PM -, Andy Hassall wrote: Any and all testing would be greatly appreciated, but especially testing of building against Oracle Instant Client and Oracle XE on a range of platforms. I've put

ANNOUNCE: DBD::Oracle 1.17 release candidate 2

2006-01-11 Thread Tim Bunce
http://www.data-plan.com/public/DBD-Oracle-1.17-RC2.tar.gz =head1 Changes in DBD-Oracle 1.17 RC2 (svn rev 2385) Fixed automatic csform setting for some UTF8 cases and for Oracle 8.0 Fixed truncation error on fetch into UTF8 charset thanks to Honza Pazdziora. Fixed INTERVAL DAY TO SECOND

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 2

2006-01-11 Thread Steffen Goeldner
Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17-RC2.tar.gz On Oracle8: # failed test 34 at line 120. ORA-00904: invalid column name (DBD ERROR: error possibly near * indicator at char 15 in ' select *to_dsinterval(:p1) from dual ') not ok 34 Patch

RE: ANNOUNCE: DBD::Oracle 1.17 release candidate 2

2006-01-11 Thread Andy Hassall
://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: 11 January 2006 12:55 To: dbi-dev@perl.org Cc: Paul Vallee; John Scoles Subject: ANNOUNCE: DBD::Oracle 1.17 release candidate 2 http://www.data-plan.com

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate 2

2006-01-11 Thread Tim Bunce
On Wed, Jan 11, 2006 at 10:06:57PM -, Andy Hassall wrote: Unable to read /u01/app/oracle/product/10.2.0/db_1/rdbms/demo/demo_xe.mk: No such file or directory at Makefile.PL line 1264. I think the following change made in r2377 is the culprit: # default to using XE .mk file if one

ANNOUNCE: DBD::Oracle 1.17 release candidate 3

2006-01-11 Thread Tim Bunce
http://www.data-plan.com/public/DBD-Oracle-1.17-RC3.tar.gz We're getting there. This one fixes the two issues raised against RC2 (thanks Andy and Steffen). I'd be grateful for more, and wider, testing. Thanks! Tim.

RE: ANNOUNCE: DBD::Oracle 1.17 release candidate

2006-01-11 Thread Andy Hassall
On Sun, Jan 01, 2006 at 11:39:17PM -, Andy Hassall wrote: Under Cygwin there are additional Unicode-related failures. Other will have to scratch that itch. I'd like to scratch, since I've written a Perl+Oracle tool at the office (an Oracle schema documentation tool) that is easier to

Re: ANNOUNCE: DBD::Oracle 1.17 release candidate

2006-01-10 Thread Tim Bunce
On Sun, Jan 01, 2006 at 11:39:17PM -, Andy Hassall wrote: Any and all testing would be greatly appreciated, but especially testing of building against Oracle Instant Client and Oracle XE on a range of platforms. I've put up a page with the test results for various combinations at:

Re: Truncation on single byte to UTF-8 conversion (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2006-01-09 Thread Tim Bunce
On Thu, Dec 29, 2005 at 11:56:27AM +0100, Honza Pazdziora wrote: On Wed, Dec 28, 2005 at 11:11:31PM +, Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17.tar.gz =head1 Changes in DBD-Oracle 1.17 (svn rev 2334) Hello Tim, it seems like the problem that I reported

Re: Truncation on single byte to UTF-8 conversion (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2006-01-03 Thread Honza Pazdziora
On Mon, Jan 02, 2006 at 11:39:39PM +, Tim Bunce wrote: Any idea what should I try next to make CS_IS_UTF8 (and fbh-csid) behave like it is supposed to? I think it only needs to *4 if the _client_ csid is utf8. Exactly. Try the attached. If that works then I think similar logic

Re: Truncation on single byte to UTF-8 conversion (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2006-01-02 Thread Tim Bunce
On Thu, Dec 29, 2005 at 11:56:27AM +0100, Honza Pazdziora wrote: case 96: /* CHAR */ fbh-disize = fbh-dbsize; if (CS_IS_UTF8(fbh-csid)) fbh-disize = fbh-dbsize * 4; fbh-prec

RE: ANNOUNCE: DBD::Oracle 1.17 release candidate

2006-01-01 Thread Andy Hassall
Any and all testing would be greatly appreciated, but especially testing of building against Oracle Instant Client and Oracle XE on a range of platforms. I've put up a page with the test results for various combinations at: http://www.andyh.co.uk/temp/DBD-Oracle/1.17RC1/ It builds

Re: PATCH: Use the correct sqlplus to find out version (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2005-12-30 Thread Tim Bunce
Applied, with thanks. Tim. On Thu, Dec 29, 2005 at 09:22:04PM +0100, Honza Pazdziora wrote: On Wed, Dec 28, 2005 at 11:11:31PM +, Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17.tar.gz =head1 Changes in DBD-Oracle 1.17 (svn rev 2334) Hello Tim, please

Re: LD_RUN_PATH would be nice for Oracle XE (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2005-12-30 Thread Tim Bunce
On Thu, Dec 29, 2005 at 10:16:41PM +0100, Honza Pazdziora wrote: On Thu, Dec 29, 2005 at 05:56:51PM +, Tim Bunce wrote: when running that make test, and better yet, by using LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib (or equivalent) when making

1.17 OK on regular 10.2.0.1 database (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2005-12-29 Thread Honza Pazdziora
On Wed, Dec 28, 2005 at 11:11:31PM +, Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17.tar.gz [...] =cut Any and all testing would be greatly appreciated, but especially testing of building against Oracle Instant Client and Oracle XE on a range of platforms.

LD_RUN_PATH would be nice for Oracle XE (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2005-12-29 Thread Honza Pazdziora
On Wed, Dec 28, 2005 at 11:11:31PM +, Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17.tar.gz =head1 Changes in DBD-Oracle 1.17 (svn rev 2334) [...] Any and all testing would be greatly appreciated, but especially testing of building against Oracle Instant Client and

Re: LD_RUN_PATH would be nice for Oracle XE (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2005-12-29 Thread Tim Bunce
On Thu, Dec 29, 2005 at 03:22:21PM +0100, Honza Pazdziora wrote: On Wed, Dec 28, 2005 at 11:11:31PM +, Tim Bunce wrote: http://www.data-plan.com/public/DBD-Oracle-1.17.tar.gz =head1 Changes in DBD-Oracle 1.17 (svn rev 2334) [...] Any and all testing would be greatly

Re: LD_RUN_PATH would be nice for Oracle XE (was: Re: ANNOUNCE: DBD::Oracle 1.17 release candidate)

2005-12-29 Thread Honza Pazdziora
On Thu, Dec 29, 2005 at 05:56:51PM +, Tim Bunce wrote: This is easily fixed by using LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib I was presuming that people would have that already. People who install the software from rpm tend to expect that all

ANNOUNCE: DBD::Oracle 1.17 release candidate

2005-12-28 Thread Tim Bunce
http://www.data-plan.com/public/DBD-Oracle-1.17.tar.gz =head1 Changes in DBD-Oracle 1.17 (svn rev 2334) Fixed csform setting for Oracle 8.0. Fixed csform setting for some UTF8 cases. Fixed INTERVAL DAY TO SECOND thanks to Honza Pazdziora. Fixed undef warnings when connecting with undef