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 DownloadResource ResourceId = 'B2Y1KS6A8873OCP2!152'"); while ($row = odbc_fetch_array($stmt)) { echo "result = ", $row["result"], "\n"; }