Scott T. Hildreth
Thu, 29 Jan 2004 13:45:38 -0800
..tried Makefile.PL -nob, but I got different error. It couldn't find upeio....something like that. Here is the some output from 'perl Makefile.PL -s OCILobWriteAppend',
searching oracle lib/libclient8.a ... OCILobWriteAppend | 0000000000004064 | T | 0000000000000008 searching oracle lib/libclntst8.a ... OCILobWriteAppend | 0000000000004064 | T | 0000000000000008 OCILobWriteAppend | 0000000000000000 | U | 0000000000000008 searching oracle lib/libcommon8.a ... searching oracle lib/libcore8.a ... searching oracle lib/libctx8.a ... OCILobWriteAppend | 0000000000000000 | U | 0000000000000008 searching oracle lib/libclntsh.so ... OCILobWriteAppend | 0004396966974288 | T | 0000000000000008 searching oracle lib/libcorejava.so ... searching oracle lib/libdsbtsh8.so ... searching oracle lib/libjip8.so ... OCILobWriteAppend | 0004396969718768 | T | 0000000000000008 searching oracle lib/libjox8.so ... searching oracle lib/liblsm.so ... searching oracle lib/libnavshr.so ... nm: Invalid file or object type searching oracle lib/libnjni8.so ... OCILobWriteAppend | 0004396962684688 | T | 0000000000000008 searching oracle lib/libnjssl8.so ... searching oracle lib/libnvbaseshr.so ... nm: Invalid file or object type searching oracle lib/libobk.so ... searching oracle lib/libocijdbc8.so ... OCILobWriteAppend | 0004396969187424 | T | 0000000000000008 searching oracle lib/libocijdbc8_g.so ... OCILobWriteAppend | 0004396962439648 | T | 0000000000000008 My LD_LIBRARY_PATH is set(same setting as when I compiled 1.14). Here is output of 'perl Makefile.PL -s OCILob On Thu, 2004-01-29 at 14:07, Scott T. Hildreth wrote: > 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.