Re: DBD:Oracle 1.15 fails for long.t test 195 to 198 (perl 5.8.3, oracle 8.1.7)

[Scott T. Hildreth]

I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7.
1.14 builds(make test), but 1.15 prints this error on first test,

t/base.......Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load
'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen:
blib/arch/auto/DBD/Oracle/Oracle.so: symbol "OCILobWriteAppend"
unresolved at /usr/local/lib/perl5/5.6.1/alpha-dec_osf/DynaLoader.pm
line 206.
 at (eval 1) line 3

I tried Makefile.PL -p as well, but no luck.  I must be missing
something, I will do a search now.........

On Thu, 2004-01-29 at 12:35, Tim Bunce wrote:
> On Wed, Jan 28, 2004 at 08:56:51PM -0500, Gerard Tromp wrote:
> > 
> > DBD::Oracle 1.15 fails for tests 195, 196, 197 and 198
> > Oracle version 8.1.7.0.0 for both server and client.
> 
> If there's anyone out there using Oracle 8.1.x could you please
> test DBD::Oracle 1.15 and let us know if it works or not for you?
> 
> > Note that DBD::Oracle 1.14 is OK (somehwat fewer tests, so perhaps the bug
> > isn't triggered -- I have not yet delved into the differrences between the
> > test sets).
> > 
> > The failure is peculiar. Oracle complains about the date format being wrong,
> > but as I understand it the date has been OK in previous and subsequent
> > queries.
> 
> I thought I'd seen it before. A little googling turned up these:
> http://www.geocrawler.com/archives/3/183/2003/1/0/10305042/
> http://www.bitmechanic.com/mail-archives/dbi-users/Jun1999/0466.html
> http://archives.neohapsis.com/archives/php/2000-02/0000.html
>  (search for "date format is too long for internal buffer" in that one)
> 
> I can't see anything in the trace file you sent.
> 
> Try running:  perl -Mblib t/long.t
> 
> and see for which LONG type you get the error, then try commenting
> out the "push @test_sets, ..." lines near the top to see if the
> error still happens when only that type is tested.
> 
> Then also try altering the "$dbh->{LongReadLen} = 20;" at line 144
> (try using 80, but make sure you're using the original oci8.c file).
> 
> Then try reducing the t/long.t file down till it's as small as
> possible but still generates the error.
> 
> Tim.