my $sth = $dbh->prepare(<<'');
INSERT INTO sometable (x, y, z, blobby) VALUES (?, ?, ?, ?)

$sth->execute('x', 'y', 'z', $blobdata);

##</code><code>##

$sth->bind_param($field_num, $lob_value, { ora_type => ORA_BLOB });