OCIDefineObject error

From: Jie Zhang (jie_at_best.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 03:44:34 -0700
To:  dbi-users@perl.org

Hi,

I'm trying to retreive a blob field from oracle database. But I keep
getting this error:

DBD::Oracle::db prepare failed: ERROR OCIDefineObject call needed but
not implemented yet [for statement ``select user_data from
cmf_balance_qt where state=3 and rownum<3'']) at ./get_blob.pl line 22.
Can't call method "execute" on an undefined value at ./get_blob.pl line 23.

user_data is a blob field.

Here is my code:
my $query1='select user_data from cmf_balance_qt where state=3 and
rownum<3';
print $query, "\n";
my $dbh = DBI->connect("DBI:Oracle:$dbname", $username,$pwd) or die
"Can't connect to database $dbname: $DBI::errstr";

$LONG_RAW_TYPE=24; # Oracle type id for blobs

$dbh->{LongReadLen} = 500000;
$dbh->{'LongTrun***'} = 1;

my $sth=$dbh->prepare($query1);
   $sth->execute;

Is this an installation problem? Any help is appreciated.

thanks,

Jie