PHP PDO Microsoft SQL Server: SQLSTATE[24000]: [Microsoft][O

我有这个php脚本，应该添加一个新的运行到系统。每次运行它时，它都会告诉我光标状态无效。我不知道为什么会发生这个错误。在进入下一段代码之前，我已经进行了closeCursor()调用。这是php脚本，它在第42行(CreatePersonalRun存储过程的执行命令)抛出错误:

if (isset($emailAddress, $caloriesBurnt, $dateRecorded, $deleted, $endTime, $startTime, $runType, $routeId)) {
$getAthleteID = $dsn->prepare("{CALL sp_GetAthleteId(?)}");
$getAthleteID->bindParam(1, $emailAddress, PDO::PARAM_STR);
$getAthleteID->execute();
$athleteData = $getAthleteID->fetch(PDO::FETCH_ASSOC);
$athleteId = $athleteData["AthleteID"];
$getAthleteID->closeCursor();
$runType = 0;
$deleted = false;
if ($athleteId != null) {
    $getAthleteID->closeCursor();
    $addRun = $dsn->prepare("{CALL sp_CreatePersonalRun(?,?,?,?,?,?,?,?)}");
    $addRun->bindValue(1, $athleteId);
    $addRun->bindValue(2, $caloriesBurnt);
    $addRun->bindValue(3, $dateRecorded);
    $addRun->bindValue(4, $deleted);
    $addRun->bindValue(5, $endTime);
    $addRun->bindValue(6, $routeId);
    $addRun->bindValue(7, $startTime);
    $addRun->bindValue(8, $runType);
    $addRun->execute(); //This is where the error is thrown
    if ($addRun->rowCount() > 0) {
        echo json_encode(array("code" => 100, "message" => "Run has been added to the system successfully!"));
    } else {
        echo json_encode(array("code" => 200, "message" => "Something went wrong with adding the run to the system"));
    }
} else {
    echo json_encode(array("code" => 200, "message" => "Athlete does not exist"));
}

getAthleteId存储过程的代码:

ALTER PROCEDURE [dbo].[sp_GetAthleteId]
@emailAddress nvarchar(400)
AS
SELECT * FROM Athlete WHERE EmailAddress = @emailAddress;