Oracle® Insurance Rules Palette Release 9.3.1.0 E21044_01

# STOREDPROCEDURE-COLLECTION

## Description

Provides the ability to call a stored procedure that returns key-value pairs. A stored procedure may return multiple rows of two columns. This is accepted by math as a collection. A collection in math is a series of key-value pairs where each key value is unique. The first column from the data return is the key and the second column is the value. All data must be compatible with the math variable data type of text though the data type for the variable is MAP. The variable type is STOREDPROCEDURE-COLLECTION.

## STOREDPROCEDURE-COLLECTION Element/Attribute Table

TYPE=STOREDPROCEDURE-COLLECTION

Element | Attributes | Attribute Value | Element Value | Definition
--- | --- | --- | --- | ---
<MathVariable> | TYPE | STOREDPROCEDURE-COLLECTION |  |
VARIABLENAME | A name that succinctly identifies the contents of the variable. |  |
PROCEDURENAME | Name of the stored procedure exactly as it is defined. |  | Provides the name of the stored procedure.
DATATYPE | MAP |  | The data type of the variable.
<Parameters> |  |  |  | Opening element that allows multiple parameters to be defined.
<Parameter> |  |  | Variable name defined in a prior math statement, literal value or expression that results in an appropriate data type. | Defines the values to be passed as input to the stored procedure.
NAME | A literal value. |  | Defines the name of the parameter exactly as defined in the stored procedure.
DATATYPE | A literal value. Values are limited to: DATE TEXT INTEGER DECIMAL |  |

## XML Sample

    <MathVariable VARIABLENAME="RateMap" TYPE="STOREDPROCEDURE-COLLECTION" DATATYPE="MAP" PROCEDURENAME="TestRateMapProc">

    <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