ArxProcedureType

Definition

Namespace

ARX.SDK.Query

Package

ARX.SDK

public enum ArxProcedureType

Values

Procedure

A stored procedure: CALL name(...). Returns OUT values and, through cursor parameters, tables.

Function

A function: SELECT * FROM name(...). Returns rows (a value, a row of OUT values, a table, a set).

Usage

var function = new ArxProcedureExpression("fn_contact_count") { ProcedureType = ArxProcedureType.Function };

Call a function: a value, rows, an effect, scenario 1

Used in:

• Call a function: a value, rows, an effectExecute
• Page through a procedure's result: the routine pages itself, ARX pages a function, ARX pages a cursorExecute
• Execute on a preloaded, Strict schema: routines aren't covered, tables areExecute