Skip Menu |
 

This queue is for tickets about the Apache-Session CPAN distribution.

Report information
The Basics
Id: 486
Status: resolved
Priority: 0/
Queue: Apache-Session

People
Owner: Nobody in particular
Requestors: ben [...] thesite.org
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 1.54
Fixed in: 1.70_01



Subject: ORA-01461occurs during Apache::Session install
Download (untitled) / with headers
text/plain 10.8k
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
Download (untitled) / with headers
text/plain 462b
On Apr 15 13:01:52 2002, guest wrote: Show quoted text
> 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?
Current version skips 99oracle.t. That test should be only run when DSN is provided. -- Alexandr Ciornii, http://chorny.net


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.