StoredProcedureCollection

The StoredProcedureCollection math variable allows for the execution of a StoredProcedure 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 the Rules Palette

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.

Define the StoredProcedureCollection Math Variable

Drag and drop the StoredProcedureCollection Math variable from the Palette window onto the Math Pane. Enter the following information for the math variable.

Check-in the transaction to save the information to the database.

     
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us