On Wed, Jul 14, 2004 at 03:02:24PM +0100, Tim Bunce wrote:
>
> http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc3-20040714.tar.gz
>
> the only extra change is to enable bind_param/execute using overloaded values.
> I wanted to get this done because it affects Class::DBI users.
>
> Again, I don't think you need to download it if you've already got an earlier RC.
> That's the last change I plan to make, unless I get word of any bugs, so please
> give it a whirl and try to break it for me :)
Hello Tim,
This is perl, v5.8.3 built for i386-linux-thread-multi, from Fedora's
perl-5.8.3-5 rpm (I can send perl -V if you think it will be usefull).
This is 9.2.0.1 client. Make gives me a couple of warnings, nothing we
couldn't live with:
gcc -c -I/data/oracle-home/rdbms/demo -I/data/oracle-home/rdbms/public
-I/data/oracle-home/plsql/public -I/data/oracle-home/network/public
-I/data/oracle-home/rdbms/demo -I/data/oracle-home/rdbms/public
-I/data/oracle-home/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBI -D_REENTRANT
-D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2\" Oracle.cOracle.c: In function
`XS_DBD__Oracle__db_ora_lob_append':
Oracle.xs:177: warning: unused variable `startp'
gcc -c -I/data/oracle-home/rdbms/demo -I/data/oracle-home/rdbms/public
-I/data/oracle-home/plsql/public -I/data/oracle-home/network/public
-I/data/oracle-home/rdbms/demo -I/data/oracle-home/rdbms/public
-I/data/oracle-home/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBI -D_REENTRANT
-D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2\" dbdimp.cdbdimp.c: In function
`dbd_discon_all':
dbdimp.c:127: warning: passing arg 2 of pointer to function from incompatible pointer
type
dbdimp.c: In function `ora_db_login6':
dbdimp.c:293: warning: unused variable `o'
dbdimp.c:294: warning: unused variable `l'
gcc -c -I/data/oracle-home/rdbms/demo -I/data/oracle-home/rdbms/public
-I/data/oracle-home/plsql/public -I/data/oracle-home/network/public
-I/data/oracle-home/rdbms/demo -I/data/oracle-home/rdbms/public
-I/data/oracle-home/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/auto/DBI -D_REENTRANT
-D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fPIC
"-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2\" oci8.c
oci8.c: In function `ora_st_prepare':
oci8.c:284: warning: `tmp' might be used uninitialized in this function
/usr/include/bits/mathinline.h: At top level:
oci8.c:568: warning: `fetch_func_nty' defined but not used
oci8.c:1002: warning: `fbh_setup_getrefpv' defined but not used
Make test, run against 8.0.5.2.1 created with ISO-8859-2 character
set, is more interesting. The output is the same for both
NLS_LANG=AMERICAN_AMERICA.UTF8 and NLS_LANG unset. I'm not sure
how the 8bit characters get through but I assume the expected:
values are those that are in the tests as expected values.
Should I make some more tests? Would TEST_VERBOSE=1 help?
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............ok
t/21nchar...............# Failed test (t/nchar_test_lib.pl at line 312)
# got: '63'
# expected: '161'
# Failed test (t/nchar_test_lib.pl at line 316)
# got: '?'
# expected: 'Ą'
# row 4: DUMP(nch) = Typ=1 Len=1: 63
# Failed test (t/nchar_test_lib.pl at line 312)
# got: '63'
# expected: '162'
# Failed test (t/nchar_test_lib.pl at line 316)
# got: '?'
# expected: '˘'
# row 5: DUMP(nch) = Typ=1 Len=1: 63
# Failed test (t/nchar_test_lib.pl at line 312)
# got: '63'
# expected: '163'
# Failed test (t/nchar_test_lib.pl at line 316)
# got: '?'
# expected: 'Ł'
# row 6: DUMP(nch) = Typ=1 Len=1: 63
# Looks like you failed 6 tests of 53.
dubious
Test returned status 6 (wstat 1536, 0x600)
Scalar found where operator expected at (eval 153) line 1, near "'int' $__val"
(Missing operator before $__val?)
DIED. FAILED tests 41-42, 45-46, 49-50
Failed 6/53 tests, 88.68% okay
t/22nchar_al32utf8......skipped
all skipped: Database NCHAR character set is not Unicode
t/22nchar_utf8..........skipped
all skipped: Database NCHAR character set is not Unicode
t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......skipped
all skipped: Database NCHAR character set is not Unicode
t/25plsql...............ok
t/30long................DBD::Oracle::db ora_lob_append failed: ORA-00600: internal
error code, arguments: [122231], [], [], [], [], [], [], [] (DBD ERROR:
OCILobWriteAppend) at t/30long.t line 317.
# Failed test (t/30long.t at line 318)
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
# Failed test (t/30long.t at line 334)
# got: 40
# expected: 45
# Failed test (t/30long.t at line 334)
# got: 41
# expected: 46
# Failed test (t/30long.t at line 334)
# got: 42
# expected: 47
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
# Failed test (t/30long.t at line 334)
# got: 40
# expected: 45
# Failed test (t/30long.t at line 334)
# got: 41
# expected: 46
# Failed test (t/30long.t at line 334)
# got: 42
# expected: 47
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
DBD::Oracle::db ora_lob_append failed: ORA-00600: internal error code, arguments:
[122231], [], [], [], [], [], [], [] (DBD ERROR: OCILobWriteAppend) at t/30long.t line
317.
# Failed test (t/30long.t at line 318)
# Failed test (t/30long.t at line 334)
# got: 40
# expected: 45
# Failed test (t/30long.t at line 334)
# got: 41
# expected: 46
# Failed test (t/30long.t at line 334)
# got: 42
# expected: 47
# Looks like you failed 18 tests of 460.
dubious
Test returned status 18 (wstat 4608, 0x1200)
DIED. FAILED tests 253, 260, 267, 271, 273, 275, 345, 352, 359, 363, 365, 367, 437,
444, 451, 455, 457, 459
Failed 18/460 tests, 96.09% okay (less 118 skipped tests: 324 okay, 70.43%)
t/31lob.................ok
t/40ph_type.............ok
t/50cursor..............ok
t/60reauth..............skipped
all skipped: no reason given
t/70meta................ok
Failed 2/18 test scripts, 88.89% okay. 24/704 subtests failed, 96.59% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/21nchar.t 6 1536 53 6 11.32% 41-42 45-46 49-50
t/30long.t 18 4608 460 18 3.91% 253 260 267 271 273 275 345 352 359
363 365 367 437 444 451 455 457 459
7 tests and 118 subtests skipped.
make: *** [test_dynamic] Error 255
--
------------------------------------------------------------------------
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
Only self-confident people can be simple.
