RE: DBD::Oracle::st ... Use of uninitialized value in subroutine entr y

From: Dan Hopkins (dan.hopkins_at_uk.easynet.net)
Date: 06/08/04 

To: 'Tim Bunce' <Tim.Bunce@pobox.com>
Date: Tue, 8 Jun 2004 14:23:00 +0100

> 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