You are here: Transaction Rules > Transaction Elements > Math Element > STOREDPROCEDURE

Oracle® Insurance XML Configuration Guide Release 9.4.1.0 E23637_01

# 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>

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents