Repost: DBD::Oracle and Oracle 8.1.6

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.

Thanks,
  Martin

• DBD::Oracle and Oracle 8.1.6 by Martin Vorlaender
• Repost: DBD::Oracle and Oracle 8.1.6 by Martin Vorlaender
• Re: Repost: DBD::Oracle and Oracle 8.1.6 by John Peacock