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 GetCallRecordings CallId = '9f2e1d0c8b7a6f5e4d3c2b1a'")
for (row in 1:nrow(results)) {
    cat(paste("result = ", results[row,]$result, "\n"))
}