CData ODBC Driver for Amazon Marketplace 2019 - Online Help
Questions / Feedback?

Executing Stored Procedures

CData ODBC Driver for Amazon Marketplace 2019 - Build 19.0.7354

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

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0