$sth->bind_param(1, $value, ... );
$sth->bind_param( 2, $value, ... );
##</code><code>##

my $sql = "INSERT INTO sometable (x, y, z, blobby) VALUES (?, ?, ?, ?)"

my $sth = $dbh->prepare( $sql );

$sth->bind_param( 1, $x );
$sth->bind_param( 2, $y );
$sth->bind_param( 3, $z );
$sth->bind_param( 4, $lob_value, { ora_type => ORA_BLOB });

$sth->execute();