| Subject: | ORA-01461occurs during Apache::Session install |
I am unable to build Apache::Session for use with Oracle 8i Enterprise, the test suite throws an ORA-01461 error ("can bind a LONG value only for insert into a LONG column") and doesn't proceed.
Is this a bug, am I doing something wrong, or is this nothing to worry about?
I have the latest versions of DBI and DBD::Oracle installed successfully.
system version details:
Perl: 5.6.1
Oracle: 8.1.5.0.0
O/S: SunOS 5.7 Generic_106541-19 sun4u sparc SUNW,Ultra-4
the command: perl -MDBD::Oracle -e"print DBD::Oracle::ORA_OCI();"
gives the output: 8
in case that's relevant
the output of:
perl -MCPAN -e 'install Apache::Session'
is given below:
CPAN: Storable loaded ok
Going to read /usr/local/lib/perl/.cpan/Metadata
Database was generated on Mon, 15 Apr 2002 01:39:34 GMT
Running install for module Apache::Session
Running make for J/JB/JBAKER/Apache-Session-1.54.tar.gz
CPAN: MD5 loaded ok
CPAN: Compress::Zlib loaded ok
Checksum for /usr/local/lib/perl/.cpan/sources/authors/id/J/JB/JBAKER/Apache-Session-1.54.tar.gz ok
Scanning cache /usr/local/lib/perl/.cpan/build for sizes
x Apache-Session-1.54, 0 bytes, 0 tape blocks
x Apache-Session-1.54/t, 0 bytes, 0 tape blocks
x Apache-Session-1.54/t/99file.t, 1302 bytes, 3 tape blocks
x Apache-Session-1.54/t/99mysql.t, 1742 bytes, 4 tape blocks
x Apache-Session-1.54/t/99md5gen.t, 1027 bytes, 3 tape blocks
x Apache-Session-1.54/t/99filelock.t, 792 bytes, 2 tape blocks
x Apache-Session-1.54/t/99uue.t, 731 bytes, 2 tape blocks
x Apache-Session-1.54/t/99storable.t, 731 bytes, 2 tape blocks
x Apache-Session-1.54/t/99oracle.t, 2021 bytes, 4 tape blocks
x Apache-Session-1.54/t/99semaphore.t, 2036 bytes, 4 tape blocks
x Apache-Session-1.54/t/99flex.t, 1069 bytes, 3 tape blocks
x Apache-Session-1.54/t/99postgres.t, 1624 bytes, 4 tape blocks
x Apache-Session-1.54/t/99nulllock.t, 269 bytes, 1 tape blocks
x Apache-Session-1.54/t/99dbfilestore.t, 1141 bytes, 3 tape blocks
x Apache-Session-1.54/t/99filestore.t, 1460 bytes, 3 tape blocks
x Apache-Session-1.54/t/99mysqllock.t, 1337 bytes, 3 tape blocks
x Apache-Session-1.54/t/99dbfile.t, 1122 bytes, 3 tape blocks
x Apache-Session-1.54/t/99moduniqgen.t, 499 bytes, 1 tape blocks
x Apache-Session-1.54/t/99mysqlstore.t, 315 bytes, 1 tape blocks
x Apache-Session-1.54/t/99base64.t, 747 bytes, 2 tape blocks
x Apache-Session-1.54/Session, 0 bytes, 0 tape blocks
x Apache-Session-1.54/Session/File.pm, 2109 bytes, 5 tape blocks
x Apache-Session-1.54/Session/Lock, 0 bytes, 0 tape blocks
x Apache-Session-1.54/Session/Lock/MySQL.pm, 3669 bytes, 8 tape blocks
x Apache-Session-1.54/Session/Lock/Null.pm, 1546 bytes, 4 tape blocks
x Apache-Session-1.54/Session/Lock/Semaphore.pm, 6689 bytes, 14 tape blocks
x Apache-Session-1.54/Session/Lock/File.pm, 5088 bytes, 10 tape blocks
x Apache-Session-1.54/Session/Generate, 0 bytes, 0 tape blocks
x Apache-Session-1.54/Session/Generate/MD5.pm, 2460 bytes, 5 tape blocks
x Apache-Session-1.54/Session/Generate/ModUsertrack.pm, 2529 bytes, 5 tape blocks
x Apache-Session-1.54/Session/Generate/ModUniqueId.pm, 1321 bytes, 3 tape blocks
x Apache-Session-1.54/Session/Serialize, 0 bytes, 0 tape blocks
x Apache-Session-1.54/Session/Serialize/Sybase.pm, 2378 bytes, 5 tape blocks
x Apache-Session-1.54/Session/Serialize/Base64.pm, 1602 bytes, 4 tape blocks
x Apache-Session-1.54/Session/Serialize/UUEncode.pm, 1599 bytes, 4 tape blocks
x Apache-Session-1.54/Session/Serialize/Storable.pm, 1386 bytes, 3 tape blocks
x Apache-Session-1.54/Session/Store, 0 bytes, 0 tape blocks
x Apache-Session-1.54/Session/Store/DBI.pm, 2801 bytes, 6 tape blocks
x Apache-Session-1.54/Session/Store/Sybase.pm, 6416 bytes, 13 tape blocks
x Apache-Session-1.54/Session/Store/File.pm, 4458 bytes, 9 tape blocks
x Apache-Session-1.54/Session/Store/DB_File.pm, 3193 bytes, 7 tape blocks
x Apache-Session-1.54/Session/Store/Postgres.pm, 4375 bytes, 9 tape blocks
x Apache-Session-1.54/Session/Store/MySQL.pm, 3222 bytes, 7 tape blocks
x Apache-Session-1.54/Session/Store/Oracle.pm, 4513 bytes, 9 tape blocks
x Apache-Session-1.54/Session/Flex.pm, 4030 bytes, 8 tape blocks
x Apache-Session-1.54/Session/Oracle.pm, 2686 bytes, 6 tape blocks
x Apache-Session-1.54/Session/Postgres.pm, 2567 bytes, 6 tape blocks
x Apache-Session-1.54/Session/MySQL.pm, 2220 bytes, 5 tape blocks
x Apache-Session-1.54/Session/DB_File.pm, 1960 bytes, 4 tape blocks
x Apache-Session-1.54/Session/Sybase.pm, 2355 bytes, 5 tape blocks
x Apache-Session-1.54/MANIFEST, 1007 bytes, 2 tape blocks
x Apache-Session-1.54/b, 0 bytes, 0 tape blocks
x Apache-Session-1.54/b/dbi.b, 845 bytes, 2 tape blocks
x Apache-Session-1.54/b/dbstore.b, 1144 bytes, 3 tape blocks
x Apache-Session-1.54/b/mysqllock.b, 1455 bytes, 3 tape blocks
x Apache-Session-1.54/b/uuevsmime.b, 1343 bytes, 3 tape blocks
x Apache-Session-1.54/b/flexpop.b, 261 bytes, 1 tape blocks
x Apache-Session-1.54/b/dbipop.b, 156 bytes, 1 tape blocks
x Apache-Session-1.54/b/dbinew.b, 190 bytes, 1 tape blocks
x Apache-Session-1.54/b/gdbm.b, 641 bytes, 2 tape blocks
x Apache-Session-1.54/README, 3006 bytes, 6 tape blocks
x Apache-Session-1.54/CHANGES, 1822 bytes, 4 tape blocks
x Apache-Session-1.54/Makefile.PL, 154 bytes, 1 tape blocks
x Apache-Session-1.54/Session.pm, 16817 bytes, 33 tape blocks
x Apache-Session-1.54/eg, 0 bytes, 0 tape blocks
x Apache-Session-1.54/eg/example.perl, 1343 bytes, 3 tape blocks
x Apache-Session-1.54/INSTALL, 270 bytes, 1 tape blocks
x Apache-Session-1.54/TODO, 14 bytes, 1 tape blocks
Removing previously used /usr/local/lib/perl/.cpan/build/Apache-Session-1.54
CPAN.pm: Going to build J/JB/JBAKER/Apache-Session-1.54.tar.gz
Checking if your kit is complete...
Looks good
Writing Makefile for Apache::Session
cp Session/File.pm blib/lib/Apache/Session/File.pm
cp Session/Lock/MySQL.pm blib/lib/Apache/Session/Lock/MySQL.pm
cp Session/Serialize/Base64.pm blib/lib/Apache/Session/Serialize/Base64.pm
cp Session/Generate/MD5.pm blib/lib/Apache/Session/Generate/MD5.pm
cp Session/Store/File.pm blib/lib/Apache/Session/Store/File.pm
cp Session/Serialize/Sybase.pm blib/lib/Apache/Session/Serialize/Sybase.pm
cp Session/Store/DBI.pm blib/lib/Apache/Session/Store/DBI.pm
cp Session/Store/DB_File.pm blib/lib/Apache/Session/Store/DB_File.pm
cp Session/Generate/ModUsertrack.pm blib/lib/Apache/Session/Generate/ModUsertrack.pm
cp Session/MySQL.pm blib/lib/Apache/Session/MySQL.pm
cp Session/DB_File.pm blib/lib/Apache/Session/DB_File.pm
cp Session/Serialize/UUEncode.pm blib/lib/Apache/Session/Serialize/UUEncode.pm
cp Session.pm blib/lib/Apache/Session.pm
cp Session/Store/Postgres.pm blib/lib/Apache/Session/Store/Postgres.pm
cp Session/Store/MySQL.pm blib/lib/Apache/Session/Store/MySQL.pm
cp Session/Sybase.pm blib/lib/Apache/Session/Sybase.pm
cp Session/Lock/Null.pm blib/lib/Apache/Session/Lock/Null.pm
cp Session/Store/Sybase.pm blib/lib/Apache/Session/Store/Sybase.pm
cp Session/Lock/Semaphore.pm blib/lib/Apache/Session/Lock/Semaphore.pm
cp Session/Generate/ModUniqueId.pm blib/lib/Apache/Session/Generate/ModUniqueId.pm
cp Session/Lock/File.pm blib/lib/Apache/Session/Lock/File.pm
cp Session/Flex.pm blib/lib/Apache/Session/Flex.pm
cp Session/Oracle.pm blib/lib/Apache/Session/Oracle.pm
cp Session/Store/Oracle.pm blib/lib/Apache/Session/Store/Oracle.pm
cp Session/Postgres.pm blib/lib/Apache/Session/Postgres.pm
cp Session/Serialize/Storable.pm blib/lib/Apache/Session/Serialize/Storable.pm
Manifying blib/man3/Apache::Session::File.3
Manifying blib/man3/Apache::Session::Lock::MySQL.3
Manifying blib/man3/Apache::Session::Serialize::Base64.3
Manifying blib/man3/Apache::Session::Generate::MD5.3
Manifying blib/man3/Apache::Session::Store::File.3
Manifying blib/man3/Apache::Session::Serialize::Sybase.3
Manifying blib/man3/Apache::Session::Store::DB_File.3
Manifying blib/man3/Apache::Session::Generate::ModUsertrack.3
Manifying blib/man3/Apache::Session::MySQL.3
Manifying blib/man3/Apache::Session::DB_File.3
Manifying blib/man3/Apache::Session::Serialize::UUEncode.3
Manifying blib/man3/Apache::Session.3
Manifying blib/man3/Apache::Session::Store::Postgres.3
Manifying blib/man3/Apache::Session::Lock::Null.3
Manifying blib/man3/Apache::Session::Sybase.3
Manifying blib/man3/Apache::Session::Store::MySQL.3
Manifying blib/man3/Apache::Session::Lock::Semaphore.3
Manifying blib/man3/Apache::Session::Store::Sybase.3
Manifying blib/man3/Apache::Session::Generate::ModUniqueId.3
Manifying blib/man3/Apache::Session::Lock::File.3
Manifying blib/man3/Apache::Session::Flex.3
Manifying blib/man3/Apache::Session::Oracle.3
Manifying blib/man3/Apache::Session::Store::Oracle.3
Manifying blib/man3/Apache::Session::Postgres.3
Manifying blib/man3/Apache::Session::Serialize::Storable.3
/usr/local/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/99base64.........ok
t/99dbfile.........ok
t/99dbfilestore....ok
t/99file...........ok
t/99filelock.......ok
t/99filestore......ok
t/99flex...........ok
t/99md5gen.........ok
t/99moduniqgen.....ok
t/99mysql..........skipped test on this platform
t/99mysqllock......skipped test on this platform
t/99mysqlstore.....skipped test on this platform
t/99nulllock.......ok
t/99oracle.........DBD::Oracle::st execute failed: ORA-01461: can bind a LONG value only for insert into a LONG column (DBD ERROR: OCIStmtExecute) at blib/lib/Apache/Session/Store/DBI.pm line 65.
(in cleanup) DBD::Oracle::st execute failed: ORA-01461: can bind a LONG value only for insert into a LONG column (DBD ERROR: OCIStmtExecute) at blib/lib/Apache/Session/Store/DBI.pm line 65.
Use of uninitialized value in string eq at t/99oracle.t line 88.
t/99oracle.........FAILED test 7
Failed 1/10 tests, 90.00% okay
t/99postgres.......skipped test on this platform
t/99semaphore......ok
t/99storable.......ok
t/99uue............ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/99oracle.t 10 1 10.00% 7
4 tests skipped.
Failed 1/18 test scripts, 94.44% okay. 1/110 subtests failed, 99.09% okay.
make: *** [test_dynamic] Error 9
/usr/local/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force