On Thu, 5 Aug 2010 13:49:57 +0200, "H.Merijn Brand"
<h.m.br...@xs4all.nl> 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 in 'select
> h_value from t_foo where <*>h_key = :p1') [for Statement "select h_value from
> t_foo where h_key = ?"] at test.pl line 23.
> DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes: expected -
> got BLOB (DBD ERROR: error possibly near <*> indicator at char 32 in 'select
> h_value from t_foo where <*>h_key = :p1') [for Statement "select h_value from
> t_foo where h_key = ?"] at test.pl line 23.
> Issuing rollback() due to DESTROY without explicit disconnect() of
> DBD::Oracle::db handle at test.pl line 23.
With 1.25rc2
$ perl /tmp/test.pl
DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes: expected -
got BLOB (DBD ERROR: error possibly near <*> indicator at char 32 in 'select
h_value from t_foo where <*>h_key = :p1') [for Statement "select h_value from
t_foo where h_key = ?"] at /tmp/test.pl line 23.
DBD::Oracle::db prepare failed: ORA-00932: inconsistent datatypes: expected -
got BLOB (DBD ERROR: error possibly near <*> indicator at char 32 in 'select
h_value from t_foo where <*>h_key = :p1') [for Statement "select h_value from
t_foo where h_key = ?"] at /tmp/test.pl line 23.
Issuing rollback() due to DESTROY without explicit disconnect() of
DBD::Oracle::db handle at /tmp/test.pl line 23.
--
H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/
using 5.00307 through 5.12 and porting perl5.13.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
