Good. That worked. I do have 1.12 installed now and I verified via the ppm version
check.
But when I run my original problem, it looks like nothing has changed. (I did get a
new window before running this).
C:\dbi_play\dbi>perl getblob
DBD::Oracle::st execute failed: ORA-00932: inconsistent datatypes (DBD: oexfet e
rror, e.g., can't select LOB fields using DBD::Oracle built for Oracle 7) at get
blob line 22.
C:\dbi_play\dbi>
Here is the describe
ppm> describe DBD-Oracle
====================
Name: DBD-Oracle
Version: 1.12
Author: Tim Bunce ([EMAIL PROTECTED])
Title: DBD-Oracle
Abstract: Oracle database driver for the DBI module
Location: ActiveState PPM2 Repository
Available Platforms:
1. MSWin32-x86-multi-thread
====================
ppm>
But my original script keeps dying (see above).
#! perl -w
use DBI;
my $ref = {
PrintError => 0,
RaiseError => 1,
AutoCommit => 1};
my $max_len = 1024;
my $dbh = DBI->connect("dbi:Oracle:x", "xxxx", "xxxx", $ref);
$dbh->{LongReadLen} = $max_len;
$sth = $dbh->prepare(qq{select preview from preview where asset_id = 'EB00000199'});
$sth->execute();
-----Original Message-----
From: Jenda Krynicky [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 3:45 PM
To: Scott Purcell; [EMAIL PROTECTED]
Subject: RE: blob error need help
From: "Scott Purcell" <[EMAIL PROTECTED]>
> I do not know how to rebuild DBD::Oracle against Oracle 8i libraries
> on my 2000 box. I do not think it is possible.
>
> I used ppm3 and did a search on the dbd-oracle. The problem is two
> come up DBD-Oracle [1.12] and DBD-Oracle [1.06] The problem is when
> you try and install, it does not let you select, so it keeps
> installing 1.06. Any more ideas?
The search returns something like
1. DBD-Oracle [1.06] ...
2. DBD-Oracle [1.12] ...
right? Just type
install 2
and press enter.
Jenda
===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery
