call_function {sqlHelpers}

Call a SQL function/procedure.

Description

Call a SQL function/procedure.

Usage

call_function(con, schema, function_name, args, dialect = "T-SQL", cast = TRUE)

Arguments

con

A database connection.

schema

A string, the schema to query.

function_name

A string, the function/procedure to query.

args

A named list or vector, names are the parameter names and values are the parameter values.

dialect

A string, "T-SQL" or "Postgresql".,

cast

TRUE/FALSE, if TRUE, will add SQL to cast the parameters to the specified type.

Value

A data.table.

Examples

call_function(con = NULL)