ODBC Driver for WooCommerce

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 Query function 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 Rows object.

rows, _ := db.Query("EXECUTE RunSystemStatusTool Id = 'clear_transients'")
defer rows.Close()

for rows.Next() {
        var (
                result string
        )

        rows.Scan(&result)
        fmt.Printf("result = %s\n", result)
}

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