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 GetRoles Account_Name = 'Checking'")
defer rows.Close()

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

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