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

Procedure for Calling Stored Procedures

The execute method can be used to call a stored procedure with the EXECUTE syntax, as described in EXECUTE Statements. As with Querying Data, the results will be available through the cursor.

cursor.execute("EXECUTE CreateAssociation SourceId = 'http://myserver:7048/DYNAMICSNAV71/OData/Customer('01234567')'")
for (result,) in cursor:
    print("result = ", result)