MigsLab SQL Server · Types · Procedures and functions
ArxProcedureType
Definition
- Namespace
ARX.SDK.Query- Package
ARX.SDK
public enum ArxProcedureTypeWhat a routine is: PostgreSQL calls them differently (CALL against SELECT), so the caller says which.
Values
ProcedureA stored procedure:
CALL name(...). Returns OUT values and, through cursor parameters, tables.FunctionA function:
SELECT * FROM name(...). Returns rows (a value, a row of OUT values, a table, a set).
Usage
A line from a verified sample; the full, runnable code is on its page.
var count = new ArxProcedureExpression("fn_order_count") { ProcedureType = ArxProcedureType.Function };Used in:
- Read functions in depth: table rows, one row, scalar values, what functions don't take, proceduresRetrieveMultiple
- Call a function: a value, rows, an effectExecute
- Page through a procedure's result: the procedure pages itself, ARX pages a function, ARX pages a result setExecute
- Execute on a preloaded, Strict schema: routines aren't covered, tables areExecute