ODBC Driver for Slack

Build 22.0.8462

Executing Stored Procedures

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

Procedure for Calling Stored Procedures

The sqlQuery 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 returned as a data frame directly from sqlQuery.

results <- sqlQuery("EXECUTE RefreshOAuthAccessToken OAuthAccessToken = 'OAuthAccessToken'")
for (row in 1:nrow(results)) {
    cat(paste("result = ", results[row,]$result, "\n"))

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462