STOREDPROCEDURE

Description

The variable type StoredProcedure provides the ability to call a stored procedure that returns a single value. The data type of the math variable must be similar to the defined return from the stored procedure. The data types available are boolean, date, decimal, integer and text.

STOREDPROCEDURE Element/Attribute Table

TYPE=STOREDPROCEDURE

Element	Attributes	Attribute Value	Element Value
<MathVariable>	TYPE	STOREDPROCEDURE
	VARIABLENAME	A name that succinctly identifies the contents of the variable.
	PROCEDURENAME	Name of the stored procedure exactly as it is defined.
	DATATYPE	A literal of one of the following: BOOLEAN DATE DECIMAL INTEGER TEXT
<Parameters>			Variable name defined in a prior math statement, literal value or expression that results in an appropriate data type.
<Parameter>	NAME	A literal value.
	DATATYPE	A literal value. Values are limited to: DATE TEXT INTEGER DECIMAL

XML Sample

<MathVariable VARIABLENAME="spRateResult" TYPE="STOREDPROCEDURE" DATATYPE="DECIMAL" PROCEDURENAME="TestRateProc">

<Parameters>

<Parameter NAME="AGE" DATATYPE="INTEGER">VarAge</Parameter>

<Parameter NAME="SEX" DATATYPE="TEXT">01</Parameter>

</Parameters>

</MathVariable>