ODBC Driver for Jira Assets

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060