You are here: Configuration > Transactions > Configuration Panes > StoredProcedure

Oracle® Insurance Rules Palette 9.4.1.0 E23637_01

# StoredProcedure

The StoredProcedure allows for execution of a Stored Procedure within the Math to return a single value, one column with multiple rows.

StoredProcedure 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 StoredProcedure Math Variable

Drag and drop the StoredProcedure 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 applicable Data Types are Boolean, Date, Decimal, Integer, and Text. This is required. The data type of the Math variable must be similar to the defined return value from the Stored Procedure.

- Make sure variable type is defined as Stored Procedure. 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, 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.

- The Stored Procedure value is the name of the Stored Procedure you wish to execute within the Math. A pre-populated drop down selection box if provided. Select the applicable Stored Procedure.
- The Input section is required in terms of the Value column. The Parameter name is pre-populated according to the requirements defined within the Stored Procedure configuration. The Data Type column is pre-populated using the data type for the Parameter as specified within the Stored Procedure configuration. The Value column requires that you select from the pre-populated drop down selection box with all previously defined Math variables of the same data type.

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

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