RE: ANNOUNCE: DBD::Oracle 1.19 release candidate 3

2006-10-30 Thread Garrett, Philip \(MAN-Corporate\) 
John Scoles wrote:
> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC3.zip
> 
> Changes in DBD-Oracle 1.19 (svn rev 7989)
> 
> Cleaned out the extra file problems from RC2
> Fixed execute_array so it will take the ora_array_chunk_size DB handle
> attribute
> Some minor changes to the POD
> 
> 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.
> 
> Please take this opportunity to try out mass updates with
> execute_array and if you can try inserting null or undef values.

Hi John,

It tests fine for me (Linux 2.6, Perl 5.8.3, DBI 1.50).

I am curious why you moved ora_array_chunk_size into the database
handle.  That particular setting seems like something that would vary
from statement to statement, esp. depending on the size of the bound
values.

Regards,
Philip

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

2006-10-30 Thread Tielman de Villiers 
On Fri, 2006-10-27 at 14:45 -0400, John Scoles 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.


Linux 2.6.17, Perl 5.8.8, DBI 1.51, Oracle XE 10.2.0.1 works fine.









[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ uname -a
Linux lmn12448 2.6.17-10-386 #2 Fri Oct 13 18:41:40 UTC 2006 i686
GNU/Linux




[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
  Platform:
osname=linux, osvers=2.6.15.7, archname=i486-linux-gnu-thread-multi
uname='linux rothera 2.6.15.7 #1 smp tue jun 27 18:34:43 utc 2006
i686 gnulinux '
config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
-Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr
-Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8
-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5
-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local
-Dsitelib=/usr/local/share/perl/5.8.8
-Dsitearch=/usr/local/lib/perl/5.8.8 -Dman1dir=/usr/share/man/man1
-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1
-Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl
-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm
-Duseshrplib -Dlibperl=libperl.so.5.8.8 -Dd_dosuid -des'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
  Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include'
ccversion='', gccversion='4.1.2 20060613 (prerelease) (Ubuntu
4.1.1-2ubuntu5)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, prototype=define
  Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.4.so, so=so, useshrplib=true,
libperl=libperl.so.5.8.8
gnulibc_version='2.4'
  Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl): 
  Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP THREADS_HAVE_PIDS USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
  Built under linux
  Compiled at Jul  7 2006 18:08:25
  @INC:
/etc/perl
/usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
/usr/local/share/perl/5.8.7
.





[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ perl Makefile.PL 
Argument "6.30_01" isn't numeric in subroutine entry at Makefile.PL line
8
main::BEGIN() called
at /usr/share/perl/5.8/ExtUtils/MakeMaker.pm line 8
eval {...} called at /usr/share/perl/5.8/ExtUtils/MakeMaker.pm
line 8
Using DBI 1.51 (for perl 5.008008 on i486-linux-gnu-thread-multi)
installed in /usr/lib/perl5/auto/DBI/
Argument "6.30_01" isn't numeric in numeric ge (>=) at Makefile.PL line
59.

Configuring DBD::Oracle for perl 5.008008 on linux
(i486-linux-gnu-thread-multi)

Remember to actually *READ* the README file! Especially if you have any
problems.

Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Looks like Oracle XE
(/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk)
Reading 
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib'

Checking for functioning wait.ph
Constant subroutine __USE_POSIX undefined
at /usr/lib/perl/5.8/features.ph line 8.
Constant subroutine __USE_POSIX2 undefined
at /usr/lib/perl/5.8/features.ph line 9.
Constant subroutine __USE_POSIX199309 undefined
at /usr/lib/perl/5.8/features.ph line 10.
Constant subroutine __USE_POSIX199506 undefined
at /usr/lib/perl/5.8/features.ph line 11.
Constant subroutine

RE: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-15 Thread Andy Hassall 
>It would be great if you could test on the Lunix version of the client 

 Similar problems show up on the Linux client as well.

>or upgrade/pathc the windows 9.2.0.8 client

 It's already at 9.2.0.8, that's the most recent patchset for 9.2.

 My batch build/test script has just finished and I've put the results up
at:

http://www.andyh.co.uk/temp/DBD-Oracle/r7940/results.php

 The "RC2" zip file in Subversion contains what looks like various test
copies of files, in particular "dbdimp_27.c", "dbdimp_fixed.c" etc., and as
a result it doesn't build. So I based the tests on an svn export of r7940.
(Not sure it's a good idea checking in temporary tarballs/zips of the
distribution into its source control repository)

Thanks,
-- 
Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED] 
Sent: 11 October 2006 16:16
To: Andy Hassall
Cc: dbi-dev@perl.org
Subject: Re: ANNOUNCE: DBD::Oracle 1.19 release candidate

Will look into this on the next RC -3.

but I think it is a bug with the windows Oracle 9.2.0.8 full client rather 
than DBD::Oracle.
Seems test 24implicit_utf8 only fails with this exact error with this 
version of the Oracle client and DB.
It would be great if you could test on the Lunix version of the client or 
upgrade/pathc the windows 9.2.0.8 client

cheers
John Scoles
- Original Message - 
From: "Andy Hassall" <[EMAIL PROTECTED]>
To: "'John Scoles'" <[EMAIL PROTECTED]>
Cc: 
Sent: Tuesday, October 10, 2006 6:59 PM
Subject: RE: ANNOUNCE: DBD::Oracle 1.19 release candidate


> Initial testing looks OK in the following, all against a
> WE8ISO8859P15/AL16UTF16 10.2.0.2 database, NLS_LANG=.WE8ISO8859P15 (not
> tried other NLS combinations yet):
>
>Cygwin (Perl 5.8.7, DBI 1.51, gcc 3.4.4)
> 9.2.0.8 full client
> 10.2.0.2 instant client
>
>Linux (Perl 5.8.8, DBI 1.52, gcc 3.4.6)
> 10.2.0.2 full client
>
>Windows (ActiveState Perl 5.8.8, DBI 1.5.2, MS Visual Studio.NET 2003)
> 10.2.0.2 instant client
> 10.2.0.1 xe client
>
> Test FAILs on:
>
>Windows (ActiveState Perl 5.8.8 build 817, DBI 1.5.2, MS Visual
> Studio.NET 2003)
> 9.2.0.8 full client
>
> t/24implicit_utf8...ok 1/74
> #   Failed test 'byte_string test of row 4: column: nch  (uft8) smiley 
> face'
> #   in t/nchar_test_lib.pl at line 341.
> #  got: '38|58'
> # expected: '226|152|186'
>
> t/24implicit_utf8...NOK 34#   Failed test 'nice_string test of row 4:
> column
> : nch  (uft8) smiley face'
> #   in t/nchar_test_lib.pl at line 344.
> #  got: '&:'
> # expected: '\x{263A}'
> #row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
>
> #   Failed test 'byte_string test of row 4: column: nch  (uft8) smiley 
> face'
> #   in t/nchar_test_lib.pl at line 341.
> #  got: '38|58'
> # expected: '226|152|186'
>
> #   Failed test 'nice_string test of row 4: column: nch  (uft8) smiley 
> face'
> #   in t/nchar_test_lib.pl at line 344.
> #  got: '&:'
> # expected: '\x{263A}'
> #row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
> t/24implicit_utf8...NOK 71# Looks like you failed 4 tests of 74.
> t/24implicit_utf8...dubious
>Test returned status 4 (wstat 1024, 0x400)
> DIED. FAILED tests 33-34, 70-71
>Failed 4/74 tests, 94.59% okay
>
> (all other tests OK)
>
> These tests also fail in the same configuration with DBD-Oracle 1.18a and
> 1.17 so it doesn't look like a totally new problem.
>
> The 2nd and 4th failures have:
>
> # expected: '\x{263A}'
> #row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
>
> 0,38,0,58 is 0x0, 0x26, 0x0, 0x3a - some sort of confusion between UTF-8
> and the UTF-16 nchar encoding?
>
> Similarly with the 1st and 3rd failures:
>
> #  got: '38|58'
> # expected: '226|152|186'
>
> It's expecting the UTF-8 encoding of \x{263A}, but it's getting the UTF-16
> encoding of it.
>
> Why it's only showing on Windows native and not Cygwin I don't know. I
> haven't got a 9.2 Linux client installed at the moment so can't check if 
> it
> fails there yet.
>
> -- 
> Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
>
> -Original Message-
> From: John Scoles [mailto:[EMAIL PROTECTED]
> Sent: 05 October 2006 16:27
> To: dbi-dev@perl.org
> Subject: ANNOUNCE: DB

Re: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-11 Thread John Scoles 

Will look into this on the next RC -3.

but I think it is a bug with the windows Oracle 9.2.0.8 full client rather 
than DBD::Oracle.
Seems test 24implicit_utf8 only fails with this exact error with this 
version of the Oracle client and DB.
It would be great if you could test on the Lunix version of the client or 
upgrade/pathc the windows 9.2.0.8 client


cheers
John Scoles
- Original Message - 
From: "Andy Hassall" <[EMAIL PROTECTED]>

To: "'John Scoles'" <[EMAIL PROTECTED]>
Cc: 
Sent: Tuesday, October 10, 2006 6:59 PM
Subject: RE: ANNOUNCE: DBD::Oracle 1.19 release candidate



Initial testing looks OK in the following, all against a
WE8ISO8859P15/AL16UTF16 10.2.0.2 database, NLS_LANG=.WE8ISO8859P15 (not
tried other NLS combinations yet):

   Cygwin (Perl 5.8.7, DBI 1.51, gcc 3.4.4)
9.2.0.8 full client
10.2.0.2 instant client

   Linux (Perl 5.8.8, DBI 1.52, gcc 3.4.6)
10.2.0.2 full client

   Windows (ActiveState Perl 5.8.8, DBI 1.5.2, MS Visual Studio.NET 2003)
10.2.0.2 instant client
10.2.0.1 xe client

Test FAILs on:

   Windows (ActiveState Perl 5.8.8 build 817, DBI 1.5.2, MS Visual
Studio.NET 2003)
9.2.0.8 full client

t/24implicit_utf8...ok 1/74
#   Failed test 'byte_string test of row 4: column: nch  (uft8) smiley 
face'

#   in t/nchar_test_lib.pl at line 341.
#  got: '38|58'
# expected: '226|152|186'

t/24implicit_utf8...NOK 34#   Failed test 'nice_string test of row 4:
column
: nch  (uft8) smiley face'
#   in t/nchar_test_lib.pl at line 344.
#  got: '&:'
# expected: '\x{263A}'
#row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58

#   Failed test 'byte_string test of row 4: column: nch  (uft8) smiley 
face'

#   in t/nchar_test_lib.pl at line 341.
#  got: '38|58'
# expected: '226|152|186'

#   Failed test 'nice_string test of row 4: column: nch  (uft8) smiley 
face'

#   in t/nchar_test_lib.pl at line 344.
#  got: '&:'
# expected: '\x{263A}'
#row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
t/24implicit_utf8...NOK 71# Looks like you failed 4 tests of 74.
t/24implicit_utf8...dubious
   Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 33-34, 70-71
   Failed 4/74 tests, 94.59% okay

(all other tests OK)

These tests also fail in the same configuration with DBD-Oracle 1.18a and
1.17 so it doesn't look like a totally new problem.

The 2nd and 4th failures have:

# expected: '\x{263A}'
#row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58

0,38,0,58 is 0x0, 0x26, 0x0, 0x3a - some sort of confusion between UTF-8
and the UTF-16 nchar encoding?

Similarly with the 1st and 3rd failures:

#  got: '38|58'
# expected: '226|152|186'

It's expecting the UTF-8 encoding of \x{263A}, but it's getting the UTF-16
encoding of it.

Why it's only showing on Windows native and not Cygwin I don't know. I
haven't got a 9.2 Linux client installed at the moment so can't check if 
it

fails there yet.

--
Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: 05 October 2006 16:27
To: dbi-dev@perl.org
Subject: ANNOUNCE: DBD::Oracle 1.19 release candidate

http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC1.zip

Changes in DBD-Oracle 1.19 (scn rev 7879)

 Fixed execute_array to comply with DBI standard from Martin J. Evans, Xho
Jingleheimerschmidt and others
 Fixed execute_array so it will not throw a Perl warning on undef values 
in


Tuples from John Scoles
 Fixed some typos in code and READMEs from John Scoles
 Fixed a few other little bugs dealing with  compatibility with Oracle 8
 Changes to README from Karl Auer
 Suppress warning in 26exe_array.t from Philip Garrett
 Added support for array context aware execute_for_fetch from Martin J.
Evans

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.

Please take this opertunitry to try out mass updates with execute_array.

Thanks!

John Scoles

RE: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-10 Thread Andy Hassall 
 Initial testing looks OK in the following, all against a
WE8ISO8859P15/AL16UTF16 10.2.0.2 database, NLS_LANG=.WE8ISO8859P15 (not
tried other NLS combinations yet):

Cygwin (Perl 5.8.7, DBI 1.51, gcc 3.4.4)
9.2.0.8 full client 
10.2.0.2 instant client

Linux (Perl 5.8.8, DBI 1.52, gcc 3.4.6)
10.2.0.2 full client

Windows (ActiveState Perl 5.8.8, DBI 1.5.2, MS Visual Studio.NET 2003)
10.2.0.2 instant client
10.2.0.1 xe client

 Test FAILs on:

Windows (ActiveState Perl 5.8.8 build 817, DBI 1.5.2, MS Visual
Studio.NET 2003)
9.2.0.8 full client

t/24implicit_utf8...ok 1/74
#   Failed test 'byte_string test of row 4: column: nch  (uft8) smiley face'
#   in t/nchar_test_lib.pl at line 341.
#  got: '38|58'
# expected: '226|152|186'

t/24implicit_utf8...NOK 34#   Failed test 'nice_string test of row 4:
column
: nch  (uft8) smiley face'
#   in t/nchar_test_lib.pl at line 344.
#  got: '&:'
# expected: '\x{263A}'
#row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58

#   Failed test 'byte_string test of row 4: column: nch  (uft8) smiley face'
#   in t/nchar_test_lib.pl at line 341.
#  got: '38|58'
# expected: '226|152|186'

#   Failed test 'nice_string test of row 4: column: nch  (uft8) smiley face'
#   in t/nchar_test_lib.pl at line 344.
#  got: '&:'
# expected: '\x{263A}'
#row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58
t/24implicit_utf8...NOK 71# Looks like you failed 4 tests of 74.
t/24implicit_utf8...dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 33-34, 70-71
Failed 4/74 tests, 94.59% okay

 (all other tests OK)

 These tests also fail in the same configuration with DBD-Oracle 1.18a and
1.17 so it doesn't look like a totally new problem.

 The 2nd and 4th failures have:

# expected: '\x{263A}'
#row 4: DUMP(nch) = Typ=1 Len=4: 0,38,0,58

 0,38,0,58 is 0x0, 0x26, 0x0, 0x3a - some sort of confusion between UTF-8
and the UTF-16 nchar encoding?

 Similarly with the 1st and 3rd failures:

#  got: '38|58'
# expected: '226|152|186'

 It's expecting the UTF-8 encoding of \x{263A}, but it's getting the UTF-16
encoding of it.

 Why it's only showing on Windows native and not Cygwin I don't know. I
haven't got a 9.2 Linux client installed at the moment so can't check if it
fails there yet.

-- 
Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED] 
Sent: 05 October 2006 16:27
To: dbi-dev@perl.org
Subject: ANNOUNCE: DBD::Oracle 1.19 release candidate

http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC1.zip

Changes in DBD-Oracle 1.19 (scn rev 7879)

  Fixed execute_array to comply with DBI standard from Martin J. Evans, Xho 
Jingleheimerschmidt and others
  Fixed execute_array so it will not throw a Perl warning on undef values in

Tuples from John Scoles
  Fixed some typos in code and READMEs from John Scoles
  Fixed a few other little bugs dealing with  compatibility with Oracle 8
  Changes to README from Karl Auer
  Suppress warning in 26exe_array.t from Philip Garrett
  Added support for array context aware execute_for_fetch from Martin J. 
Evans

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.

Please take this opertunitry to try out mass updates with execute_array.

Thanks!

John Scoles

Re: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-06 Thread John Scoles 

Just has a look at some older emails and here is what I found


FYI I'm planning on making the next release (1.51) be the last that
officially supports perl 5.6.


So I guess you will have to upgrade your perl to 5.8

cheers

John Scoles

- Original Message - 
From: "John Scoles" <[EMAIL PROTECTED]>

To: "Steffen Goeldner" <[EMAIL PROTECTED]>
Cc: 
Sent: Friday, October 06, 2006 7:26 AM
Subject: Re: ANNOUNCE: DBD::Oracle 1.19 release candidate


Great I will have a look at this today. But it look like your OCI is quite 
old with Oracle 8.1 and your perl is also olde at perl5.006001 you might 
want to try upgrading your active perl to 5.8 and try the compile again.


cheers
John Scoles
- Original Message - 
From: "Steffen Goeldner" <[EMAIL PROTECTED]>

To: "John Scoles" <[EMAIL PROTECTED]>
Cc: 
Sent: Friday, October 06, 2006 6:04 AM
Subject: Re: ANNOUNCE: DBD::Oracle 1.19 release candidate



John Scoles wrote:


http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC1.zip

Changes in DBD-Oracle 1.19 (scn rev 7879)

  Fixed execute_array to comply with DBI standard from Martin J. Evans, 
Xho Jingleheimerschmidt and others
  Fixed execute_array so it will not throw a Perl warning on undef 
values in Tuples from John Scoles

  Fixed some typos in code and READMEs from John Scoles
  Fixed a few other little bugs dealing with  compatibility with Oracle 
8

  Changes to README from Karl Auer
  Suppress warning in 26exe_array.t from Philip Garrett
  Added support for array context aware execute_for_fetch from Martin J. 
Evans


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.


Using DBI 1.52 (for perl 5.006001 on MSWin32-x86-multi-thread)
Oracle version 8.1.7.0 (8.1)
System: perl5.006001
Compiler: 
bcc32 -O2 -5 -D_RTLDLL -O2 -5 -D_RTLDLL -g0 -DWIN32 -DHAVE_DES_FCRYPT -D_MT 
 -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS


dbdimp.c:
Error E2268 dbdimp.c 339: Call to undefined function 'SvLOCK' in function 
ora_db_login6(sv *,imp_dbh_st *,char *,char *,char *,sv *)
Error E2268 dbdimp.c 765: Call to undefined function 'SvLOCK' in function 
ora_db_disconnect(sv *,imp_dbh_st *)
Error E2268 dbdimp.c 803: Call to undefined function 'SvLOCK' in function 
ora_db_destroy(sv *,imp_dbh_st *)

Warning W8054 dbdimp.c 1796: Style of function definition is now obsolete
Warning W8054 dbdimp.c 1829: Style of function definition is now obsolete
Warning W8054 dbdimp.c 1847: Style of function definition is now obsolete
Error E2034 dbdimp.c 1864: Cannot convert 'void *' to 'phs_st * *' in 
function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1889: Call to function 
'init_bind_for_array_exec()' with no prototype in function 
ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1931: Call to function 'do_bind_array_exec()' with 
no prototype in function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1966: Call to function 
'init_bind_for_array_exec()' with no prototype in function 
ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1999: Call to function 'do_bind_array_exec()' with 
no prototype in function ora_st_bind_for_array_exec()

Warning W8054 dbdimp.c 2015: Style of function definition is now obsolete
Warning W8065 dbdimp.c 2090: Call to function 
'ora_st_bind_for_array_exec()' with no prototype in function 
ora_st_execute_array(sv *,imp_sth_st *,sv *,sv *,sv *,unsigned int)
Error E2034 dbdimp.c 2128: Cannot convert 'void *' to 'void * *' in 
function ora_st_execute_array(sv *,imp_sth_st *,sv *,sv *,sv *,unsigned 
int)
Error E2342 dbdimp.c 2128: Type mismatch in parameter 'parmdpp' (wanted 
'void * *', got 'void *') in function ora_st_execute_array(sv 
*,imp_sth_st *,sv *,sv *,sv *,unsigned int)

*** 6 errors in Compile ***
dmake.exe:  Error code 1, while making 'dbdimp.obj'


FYI (regarding SvLOCK), dbipport.h defines PERL_MAGIC_shared_scalar since 
1.51, thus this w/o


  <http://www.xray.mpe.mpg.de/mailing-lists/dbi/2003-03/msg00381.html>

ceases to work.


Steffen

Re: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-06 Thread Steffen Goeldner 

John Scoles wrote:


http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC1.zip

Changes in DBD-Oracle 1.19 (scn rev 7879)

  Fixed execute_array to comply with DBI standard from Martin J. Evans, Xho 
Jingleheimerschmidt and others
  Fixed execute_array so it will not throw a Perl warning on undef values in 
Tuples from John Scoles

  Fixed some typos in code and READMEs from John Scoles
  Fixed a few other little bugs dealing with  compatibility with Oracle 8
  Changes to README from Karl Auer
  Suppress warning in 26exe_array.t from Philip Garrett
  Added support for array context aware execute_for_fetch from Martin J. 
Evans


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.


Using DBI 1.52 (for perl 5.006001 on MSWin32-x86-multi-thread)
Oracle version 8.1.7.0 (8.1)
System: perl5.006001
Compiler:   bcc32 -O2 -5 -D_RTLDLL -O2 -5 -D_RTLDLL -g0 -DWIN32 
-DHAVE_DES_FCRYPT -D_MT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS

dbdimp.c:
Error E2268 dbdimp.c 339: Call to undefined function 'SvLOCK' in function 
ora_db_login6(sv *,imp_dbh_st *,char *,char *,char *,sv *)
Error E2268 dbdimp.c 765: Call to undefined function 'SvLOCK' in function 
ora_db_disconnect(sv *,imp_dbh_st *)
Error E2268 dbdimp.c 803: Call to undefined function 'SvLOCK' in function 
ora_db_destroy(sv *,imp_dbh_st *)
Warning W8054 dbdimp.c 1796: Style of function definition is now obsolete
Warning W8054 dbdimp.c 1829: Style of function definition is now obsolete
Warning W8054 dbdimp.c 1847: Style of function definition is now obsolete
Error E2034 dbdimp.c 1864: Cannot convert 'void *' to 'phs_st * *' in function 
ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1889: Call to function 'init_bind_for_array_exec()' with 
no prototype in function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1931: Call to function 'do_bind_array_exec()' with no 
prototype in function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1966: Call to function 'init_bind_for_array_exec()' with 
no prototype in function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1999: Call to function 'do_bind_array_exec()' with no 
prototype in function ora_st_bind_for_array_exec()
Warning W8054 dbdimp.c 2015: Style of function definition is now obsolete
Warning W8065 dbdimp.c 2090: Call to function 'ora_st_bind_for_array_exec()' 
with no prototype in function ora_st_execute_array(sv *,imp_sth_st *,sv *,sv 
*,sv *,unsigned int)
Error E2034 dbdimp.c 2128: Cannot convert 'void *' to 'void * *' in function 
ora_st_execute_array(sv *,imp_sth_st *,sv *,sv *,sv *,unsigned int)
Error E2342 dbdimp.c 2128: Type mismatch in parameter 'parmdpp' (wanted 'void * 
*', got 'void *') in function ora_st_execute_array(sv *,imp_sth_st *,sv *,sv 
*,sv *,unsigned int)
*** 6 errors in Compile ***
dmake.exe:  Error code 1, while making 'dbdimp.obj'


FYI (regarding SvLOCK), dbipport.h defines PERL_MAGIC_shared_scalar since 1.51, 
thus this w/o

  

ceases to work.


Steffen

Re: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-06 Thread John Scoles 
Great I will have a look at this today. But it look like your OCI is quite 
old with Oracle 8.1 and your perl is also olde at perl5.006001 you might 
want to try upgrading your active perl to 5.8 and try the compile again.


cheers
John Scoles
- Original Message - 
From: "Steffen Goeldner" <[EMAIL PROTECTED]>

To: "John Scoles" <[EMAIL PROTECTED]>
Cc: 
Sent: Friday, October 06, 2006 6:04 AM
Subject: Re: ANNOUNCE: DBD::Oracle 1.19 release candidate



John Scoles wrote:


http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC1.zip

Changes in DBD-Oracle 1.19 (scn rev 7879)

  Fixed execute_array to comply with DBI standard from Martin J. Evans, 
Xho Jingleheimerschmidt and others
  Fixed execute_array so it will not throw a Perl warning on undef values 
in Tuples from John Scoles

  Fixed some typos in code and READMEs from John Scoles
  Fixed a few other little bugs dealing with  compatibility with Oracle 8
  Changes to README from Karl Auer
  Suppress warning in 26exe_array.t from Philip Garrett
  Added support for array context aware execute_for_fetch from Martin J. 
Evans


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.


Using DBI 1.52 (for perl 5.006001 on MSWin32-x86-multi-thread)
Oracle version 8.1.7.0 (8.1)
System: perl5.006001
Compiler: 
  bcc32 -O2 -5 -D_RTLDLL -O2 -5 -D_RTLDLL -g0 -DWIN32 -DHAVE_DES_FCRYPT -D_MT 
 -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS


dbdimp.c:
Error E2268 dbdimp.c 339: Call to undefined function 'SvLOCK' in function 
ora_db_login6(sv *,imp_dbh_st *,char *,char *,char *,sv *)
Error E2268 dbdimp.c 765: Call to undefined function 'SvLOCK' in function 
ora_db_disconnect(sv *,imp_dbh_st *)
Error E2268 dbdimp.c 803: Call to undefined function 'SvLOCK' in function 
ora_db_destroy(sv *,imp_dbh_st *)

Warning W8054 dbdimp.c 1796: Style of function definition is now obsolete
Warning W8054 dbdimp.c 1829: Style of function definition is now obsolete
Warning W8054 dbdimp.c 1847: Style of function definition is now obsolete
Error E2034 dbdimp.c 1864: Cannot convert 'void *' to 'phs_st * *' in 
function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1889: Call to function 'init_bind_for_array_exec()' 
with no prototype in function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1931: Call to function 'do_bind_array_exec()' with 
no prototype in function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1966: Call to function 'init_bind_for_array_exec()' 
with no prototype in function ora_st_bind_for_array_exec()
Warning W8065 dbdimp.c 1999: Call to function 'do_bind_array_exec()' with 
no prototype in function ora_st_bind_for_array_exec()

Warning W8054 dbdimp.c 2015: Style of function definition is now obsolete
Warning W8065 dbdimp.c 2090: Call to function 
'ora_st_bind_for_array_exec()' with no prototype in function 
ora_st_execute_array(sv *,imp_sth_st *,sv *,sv *,sv *,unsigned int)
Error E2034 dbdimp.c 2128: Cannot convert 'void *' to 'void * *' in 
function ora_st_execute_array(sv *,imp_sth_st *,sv *,sv *,sv *,unsigned 
int)
Error E2342 dbdimp.c 2128: Type mismatch in parameter 'parmdpp' (wanted 
'void * *', got 'void *') in function ora_st_execute_array(sv *,imp_sth_st 
*,sv *,sv *,sv *,unsigned int)

*** 6 errors in Compile ***
dmake.exe:  Error code 1, while making 'dbdimp.obj'


FYI (regarding SvLOCK), dbipport.h defines PERL_MAGIC_shared_scalar since 
1.51, thus this w/o


  <http://www.xray.mpe.mpg.de/mailing-lists/dbi/2003-03/msg00381.html>

ceases to work.


Steffen

RE: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-05 Thread Garrett, Philip \(MAN-Corporate\) 
John Scoles wrote:
> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC1.zip
> 
> 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.

Hi John,

All tests ok for me, running on Linux i686 SMP (SLES 9).

Database and client versions and character sets:
Database 9.2.0.5.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is
AL16UTF16 (Unicode)
Client 9.2.0.4 NLS_LANG is '', NLS_NCHAR is ''

Philip

RE: ANNOUNCE: DBD::Oracle 1.19 release candidate

2006-10-05 Thread Martin J. Evans 

On 05-Oct-2006 John Scoles wrote:
> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.19-RC1.zip
> 
> Changes in DBD-Oracle 1.19 (scn rev 7879)
> 
>   Fixed execute_array to comply with DBI standard from Martin J. Evans, Xho 
> Jingleheimerschmidt and others
>   Fixed execute_array so it will not throw a Perl warning on undef values in 
> Tuples from John Scoles
>   Fixed some typos in code and READMEs from John Scoles
>   Fixed a few other little bugs dealing with  compatibility with Oracle 8
>   Changes to README from Karl Auer
>   Suppress warning in 26exe_array.t from Philip Garrett
>   Added support for array context aware execute_for_fetch from Martin J. 
> Evans
> 
> 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.
> 
> Please take this opertunitry to try out mass updates with execute_array.
> 
> Thanks!
> 
> John Scoles

built and tests ok against Oracle XE 10.2.0.1 on Linux.

execute_array seems to work as per the specs.

Appears to work with our application so far.

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com