$sth = $dbh->prepare("execute sp_test_1 ?");
$sth->execute($y) or die "execute: $!";

##</code><code>##

$dbh->do("execute sp_test_1 '$y'");

# or
$sth = $dbh->prepare("execute sp_test_1 '$y'");
$sth->execute;