John Scoles wrote:
http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.20-RC1.tar.gz
Changes in DBD-Oracle 1.20 (svn rev 10347)
Fixed lob test so it skips the one test that relies on it if v$
session. from Rafael Kitover
Fixed // with /* */ in dbdimp.c from John Scoles
Fixed for execute_for_fetch in Oracle.pm returning 0 instead of 0E0.
from Martin J. Evans
Added README.64bit.txt that contains help for compiling on 64 bit boxes
from John Scoles
Fixed typo in Oracle.pm from Tom R.
Added support for ora_charset, ora_ncharset from Stephen J. Smith
Fixed Makefile.PL for better handling of empty array in
File::Find::find from Slaven Rezic
Fixed references to README.clients.txt in Makefile.PL from John Scoles
Added PERL_NO_GET_CONTEXT for better multi-threaded support from John
Scoles
Changed required version of DBI to be 1.51 from John Scoles
Fixed bug in 31lob.t from John Scoles
Added notes on installing Instantclient .rpm to README.Lunix.txt
Added support for OCI array bind from Alexander V Alekseev
Added support for select of OCI Embedded Objects from John Scoles
Added a tip in README.64bit.txt from cartmanltd
Added fix to Makefile.PL for finding SQLplus for Ubuntu Server (but
should work for others) from Martin J. Evans Added fix to Makefile.PL
for Gentoo AMD64 from Tom R.
Added Fix to dbdimp.c for speed up of Null-Operation speeds from
Andreas Behal
Any and all testing would be greatly appreciated, but especially
testing of building against Oracle Instant Client on a range of platforms.
There are two warnings that may appear, 'OCIObjectGetAttr' and
'OCIObjectPin' as 'undefined'. This appears to be bug in Oracle code
while annoying it does not seem to cause any problems.
This is a 'Big' release with two new features
1) Support for OCI Array bind and
2) Support for Select of OCI Embedded Objects
See the pod for details on these new features.
As well DBD::Oracle now requires that you use DBI 1.51 or later as a
number of the new features require it.
Thanks!
John Scoles
Thanks John. I am particularly looking forward to trying the new
features and will get back to you when I have.
Passes all tests executed on two of my Linux boxes to Oracle XE and 10G.
The compilation has a large number of warnings (see attachment).
As you are considering a new release there are a few minor issues
arising on dbi-dev and dbi-users I'd like to bring your attention to:
There does not seem to be any resolution to the TWO_TASK documentation
issue a few people mentioned in
http://www.nntp.perl.org/group/perl.dbi.users/2007/09/msg32045.html. As
far as I can see no one has yet admitted to using TWO_TASK as documented
and it working.
There are issues binding utf8 data to certain columns and I'm still
trying to work out a full solution rather than a work around but at a
minimum there is a small tracing error mentioned at
http://www.mail-archive.com/[EMAIL PROTECTED]/msg30138.html you may
want to put right as it has led to some confusion:
It is now line 1299 in dbdimp.c:
(csform == SQLCS_NCHAR) ? "so setting csform=SQLCS_IMPLICIT" :
(csform == SQLCS_IMPLICIT) ? "so
setting csform=SQLCS_NCHAR" :
There are a number of links in "Oracle Related Links" that no longer work:
http://www.datamgmt.com/maillist.html - not found
http://www.wmd.de/wmd/staff/pauck/misc/oracle_on_linux.html - redirect
and cannot find that page now
ftp://oracle-ftp.oracle.com/server/patch_sets/LINUX - not found
Lastly, I see your last version (1.19) is getting 100% failure from cpan
testers. It seems few of them have oracle installed - what a surprise,
or DBI installed. I believe if you simply exit your Makefile.PL with
success, without generating a Makefile you will make these go away - see
http://www.nntp.perl.org/group/perl.dbi.dev/2007/11/msg5180.html. The
testers also seem to have found an issue using BAILOUT instead of
BAIL_OUT in t/10general.t (see
http://www.nntp.perl.org/group/perl.cpan.testers/2007/09/msg611984.html).
If I can be of any further help on any of the issues mentioned let me know.
Thanks again for all your work on this and to all who contributed.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g"
/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/Driver.xst >
Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc
&& mv Oracle.xsc Oracle.c
gcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX
-D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing
-pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
-fasynchronous-unwind-tables -DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
gcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX
-D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing
-pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
-fasynchronous-unwind-tables -DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
dbdimp.c: In function 'ora_db_login6':
dbdimp.c:520: warning: pointer targets in passing argument 2 of
'OCINlsCharSetNameToId' differ in signedness
dbdimp.c:532: warning: pointer targets in passing argument 2 of
'OCINlsCharSetNameToId' differ in signedness
dbdimp.c:746: warning: value computed is not used
dbdimp.c: In function 'dbd_rebind_ph_varchar2_table':
dbdimp.c:1271: warning: value computed is not used
dbdimp.c:1406: warning: pointer targets in passing argument 13 of
'OCIBindByName' differ in signedness
dbdimp.c: In function 'dbd_rebind_ph_number_table':
dbdimp.c:1813: warning: pointer targets in passing argument 13 of
'OCIBindByName' differ in signedness
dbdimp.c:1604: warning: unused variable 'flag_data_is_utf8'
dbdimp.c: In function 'dbd_rebind_ph_char':
dbdimp.c:2026: warning: value computed is not used
dbdimp.c: In function 'ora_st_execute_array':
dbdimp.c:2961: warning: value computed is not used
gcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/ -DLINUX
-D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing
-pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
-fasynchronous-unwind-tables -DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
oci8.c: In function 'fetch_func_rset':
oci8.c:668: warning: value computed is not used
oci8.c: In function 'dbd_rebind_ph_lob':
oci8.c:767: warning: value computed is not used
oci8.c:798: warning: value computed is not used
oci8.c: In function 'get_attr_val':
oci8.c:1315: warning: pointer targets in passing argument 2 of 'Perl_newSVpv'
differ in signedness
oci8.c:1335: warning: pointer targets in passing argument 2 of 'Perl_newSVpv'
differ in signedness
oci8.c: In function 'get_object':
oci8.c:1397: warning: implicit declaration of function 'OCIObjectGetAttr'
oci8.c:1409: warning: unused variable 'emb_obj'
oci8.c: In function 'fetch_func_oci_object':
oci8.c:1540: warning: unused variable 'num_errors'
oci8.c: In function 'describe_obj':
oci8.c:1645: warning: pointer targets in passing argument 4 of 'OCITypeByName'
differ in signedness
oci8.c:1691: warning: implicit declaration of function 'OCIObjectPin'
oci8.c:1676: warning: unused variable 'namef'
oci8.c:1759: warning: unused variable 'parmap'
oci8.c:1625: warning: unused variable 'imp_dbh'
oci8.c: In function 'dump_struct':
oci8.c:1805: warning: unused variable 'imp_dbh'
oci8.c: In function 'ora_describe':
oci8.c:2156: warning: passing argument 4 of 'OCIDefineObject' from incompatible
pointer type
oci8.c: In function 'post_execute_lobs':
oci8.c:2824: warning: value computed is not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib" gcc
-shared -L/usr/local/lib Oracle.o dbdimp.o oci8.o -o
blib/arch/auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh
-lpthread \
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm
