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->{'LongTruncOk'} = 1;my $sth=$dbh->prepare($query1); $sth->execute;
Is this an installation problem? Any help is appreciated.
thanks,
Jie
