$var1 = 'text';
$var2 = 1;
$var3 = $foo;

$Query = "EXEC $Stored_procedure ?, ?, ?";

my $sthB_A =  $dbh->prepare($Query) or die "Couldn't prepare query: ".$dbh->errstr;

$sthB_A->execute($var1, $var2, $var3) or die "Couldn't execute query: ".$sthB_A->errstr;