ODBC Driver for SendGrid

Build 20.0.7587

Executing Stored Procedures

The following code example shows how to execute stored procedures and retrieve their results.

Procedure for Calling Stored Procedures

The odbc_exec function called be used to call a stored procedure with the EXECUTE syntax, as described in EXECUTE Statements. As with Querying Data, the results can be obtained by iterating on the returned resource.

$stmt = odbc_exec($cnx, "EXECUTE AddRecipientToList ListId = '63777'");
while ($row = odbc_fetch_array($stmt)) {
    echo "result = ", $row["result"], "\n";
}

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587