are you asking which comes first? The bind_param or the execute?

if you want to bind multiple parameters, just execute multiple bind_param statements with the first param the incremental parameter number.

$sth->bind_param(1, $value, ... );
$sth->bind_param( 2, $value, ... );
[download]

If that's the case, the bind_param will come after the prepare and before the execute. If it's not, please elucidate :-D

Update:
I see what you're trying...

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();
[download]