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