PHP SQL Server: Call Stored Proceduree PDO MSSQL PARAM OUT

index.php

<?php

try  
{ 
  $conn = new PDO ("sqlsrv:server=(local);Database=DatabaseName", "user", "password");
  $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );  
  
  // Param
  $idReturn = 0; // Param Out
  $name = 'Name'; // Pram In
  
  $query = "{? = call sp_getIdFromName(?)}";
  
  $stmt = $database->pdo->prepare($query);
  $stmt->bindParam(1, $idReturn, PDO::PARAM_INT|PDO::PARAM_INPUT_OUTPUT, 4);
  $stmt->bindParam(2, $name, PDO::PARAM_STR);
  
  $stmt->execute();
  echo $idReturn;
}  
catch(Exception $e)  
{   
    die( print_r( $e->getMessage() ) );   
}