Front page | perl.vmsperl |
Postings from February 2002
Re: Repost: DBD::Oracle and Oracle 8.1.6
Thread Previous
From:
John Peacock
Date:
February 1, 2002 08:24
Subject:
Re: Repost: DBD::Oracle and Oracle 8.1.6
Message ID:
3C5AC143.D026A3CA@rowman.com
Martin Vorlaender wrote:
>
> I wrote on December 13, 2001:
> > has anyone successfully built DBD::Oracle on VMS with Oracle 8.1.6
> > without using the -8 switch?
> >
> > I supposedly need OCI v8 for an application that wants to use LOBs.
> > The error message when running the setup script is:
> >
> > DBD::Oracle::st execute failed:
> > ORA-00932: inconsistent datatypes (DBD: oexfet error, e.g.,
> > can't select LOB fields using DBD::Oracle built for Oracle 7)
> > at /perl_root/lib/site_perl/DBIx/SearchBuilder/Handle.pm line 320.
> > RT::Handle=HASH(0x1df48c) couldn't execute the query
> > 'SELECT * FROM Users WHERE id = ?'
> >
> > (formatting mine)
> >
> > Even after installing the ProgInt package, I seem to be missing
> > at least oci1.h (which is included by ora_root:[rdbms]oci.h)
> > when building for v8 (i.e. without -8).
>
> Doesn't anyone do OCI programming under VMS?
>
> This is a just-looking-into-it, so it's not an overly important
> project (RT 2.0.9, a request tracker ticket system; for details see
> http://www.fsck.com/projects/rt/), but I can't believe I'm slipping
> over such a "trivial" issue.
Sorry, I meant to reply to you when you originally posted but I got distracted.
We are using DBD::Oracle under Oracle 8.1.7 in Oracle8 mode without problems.
I did have to make a few changes to the Makefile.PL to get everything to work
(diff attached due to long lines).
There were also test failures in [.t]long.t:
Failed 39/143 tests, 72.73% okay
Failed Test Status Wstat Total Fail Failed List of Failed
--------------------------------------------------------------------------------
[.t]long.t 143 39 27.27% 9-10, 16, 72-74, 78-80, 84-86, 90
,
92, 94, 98-99, 101-102, 104-105,
107-109, 113-115, 119-121, 125,
127, 129, 133-134, 136-137, 139-140
but those are to be expected according to the warning that printed. We don't
use longs or LOB's so I never investigated what failures those were; YMMV.
HTH
John
--
John Peacock
Director of Information Research and Technology
Rowman & Littlefield Publishing Group
4720 Boston Way
Lanham, MD 20706
301-459-3366 x.5010
fax 301-429-5747
Thread Previous