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

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