CData Python Connector for Microsoft Planner

Build 24.0.9062

Calling Stored Procedures

You can execute stored procedures using either the execute() or callproc() method of the connection.

Calling Stored Procedures Using Execute()

When you call stored procedures by issuing EXECUTE commands, the stored procedure arguments are parameterized. For example:
cmd = "EXECUTE UpdateAssignedToTaskBoardFormat TaskId = ?"
params = ["BCrvyMoiLEafem-3RxIESmUAHbLK"]
conn.execute(cmd, params)

Calling Stored Procedures Using Callproc()

When you call stored procedured by issuing the callproc() method, the stored procedure arguments are a procedure name and a list of parameters. For example:
cur = conn.cursor()
params = ["BCrvyMoiLEafem-3RxIESmUAHbLK"]
cur.callproc("UpdateAssignedToTaskBoardFormat", params)

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