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