Install DBD from xmlproj.com/PPM
These are compiled with V8 libs, ActiveState's aren't.
Jared
On Monday 17 February 2003 14:00, Scott Purcell wrote:
> 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
