Re: DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes

2010-08-05 Thread H.Merijn Brand
On Thu, 5 Aug 2010 13:49:57 +0200, "H.Merijn Brand" wrote: > my $sth = $dbh->prepare ("select h_value from t_foo where h_key = ?"); > $ perl test.pl > DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes: expected - > got BLOB (DBD ERROR: error possibly near <*> indicator at char 32

DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes

2010-08-05 Thread H.Merijn Brand
I cannot do a bind_param () before I prepare, but prepare () already fails :( $ cat test.pl use strict; use warnings; use DBI; my $dbh = DBI->connect ("dbi:Oracle:", $ENV{DBI_USER}, $ENV{DBI_PASS}, { PrintError => 1, RaiseError => 1, PrintWarn=> 1, FetchHashKe