Still not working. Do you have a working example I could see?

Code now looks like and gets can't call bind_param on an undefined value but I don't know what it's on about.

# prepare update statement
print "INFO: reading $photo to blob\n";
open (BLOB, "<$photo") or die "Can't open $photo: $!";
binmode BLOB;
local($/) = undef;
$blob = <BLOB>;
close (BLOB);

my $sth = $dbh->prepare ("update ssi_pri_photos set recorded = sysdate
+, recorded_by = 'David', photograph = ? where number = $id");

$sth->bind_param(1, $blob, {ora_type => ORA_BLOB, ora_field => 'photog
+raph'});
[download]

I've tried putting in 113 for ORA_BLOB too but that didn't make any difference.

Any ideas?

Thanks,
David