> On Mon, Jun 07, 2004 at 09:52:43PM +0100, Tim Bunce wrote: > > On Mon, Jun 07, 2004 at 12:06:48PM +0100, Dan Hopkins wrote: > > > > For some reason the err value for the handle is being set to zero > > (instead of being left as undef) when there's no apparent error. > > But I can't see a code path that would act in that way. > > > > [Please send a level 9 trace to me, not the list. Thanks.] > > > > Possibly it's an interaction between the DBI's new mechanism for > > warn/info messages and a code path in DBD::Oracle that calls the > > oci_error function when there's no actual error. > > Ah, found it in the old Oracle 7 OCI code... delete this line: > > sv_setiv(DBIc_ERR(imp_sth), 0); /* ensure errno set to 0 here */ > > from oci7.c (probably line 341).
Excellent, that did the trick - thanks a lot. > > You have to use "perl Makefile.PL -8" to build using Oracle 7 OCI. > > But that's history now as the next release doesn't support > Oracle 7 at all. > > > > Tim. BTW 1.15 still fails to build for me - this is likely my end again :) either way it's purely FYI, 1.14 works fine for my needs ... and it's well after time I upgraded gcc -c -I/export/home/oracle/app/oracle/product/7.3.4//rdbms/demo -I/export/home/oracle/app/oracle/product/7.3.4//rdbms/public -I. -I/export/home/oracle/app/oracle/product/7.3.4//rdbms/demo -I/export/home/oracle/app/oracle/product/7.3.4//rdbms/public -I/usr/local/lib/perl5/site_perl/5.8.4/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.15\" -DXS_VERSION=\"1.15\" -fPIC "-I/usr/local/lib/perl5/5.8.4/sun4-solaris/CORE" -DNO_OCI8 -DUTF8_SUPPORT Oracle.c Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_write': Oracle.c:1165: error: `OCILobLocator' undeclared (first use in this function) Oracle.c:1165: error: (Each undeclared identifier is reported only once Oracle.c:1165: error: for each function it appears in.) . . Cheers, -- Dan
