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