Oracle® Insurance Rules Palette
The StoredProcedureCollection math variable allows for the execution of a Stored Procedure within the Math to return multiple columns with multiple rows of data. A Collection in Math is a series of key-value pairs where each key is unique. The first column from the data return is the key and the second is the value.
StoredProcedureCollection Math Variable in Palette
Note: For a comprehensive explanation of the characteristics of this math variable, refer to the XML Configuration Guide in the Help menu.
Drag and drop the StoredProcedureCollection Math variable from the Palette window onto the Math Pane. Enter the following information for the math variable.
Type a name in the Name field. This is required.
The Data Type is MAP, always.
Make sure variable type is defined as Stored Procedure Collection. This is required.
Select Yes or No from Log field. Default is No. This is an optional field.
Round offers the option of Yes or No. Round is only enabled if select the Decimal in the data type property. If you would like to round the Decimal or Integer, select Yes. Enter the number of decimal places to round the result value. Note: When the data type of Decimal is selected, the default value for Round is set to No. You must change the selection of the radio button to Yes if you wish to round.
Default is used for a Decimal or Integer value so the system will not return a null value. For example, the default for an Integer data type could be -999999999.
NoteThe Math variable filing the parameter can be a previously defined Math variable, a literal value, or an expression.
Check-in the transaction to save the information to the database.
Copyright © 2009, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices