Loading...

Configuring List Inputs for Oracle Database Reports

To create any kind of list input in your reports from an Oracle database data set, you must first globally define some collection types in your Oracle database.

About This Task

For instructions on how to add additional settings from the CommCell Console, see Add or Modify an Additional Setting.

Procedure

  1. Create the collection types for list inputs automatically using an additional setting, or create the collection types manually in the Oracle database:
    • To enable the Custom Reports Engine (CRE) to automatically create the Oracle collection types, in the CommCell Console, add the autoCreateListType additional setting and configure the following values:

      Property

      Value

      Name

      autoCreateListType

      Category

      CustomReportsEngine

      Type

      Boolean

      Value

      1

    • To manually configure each collection type, in the Oracle database, create the following collection types:
      • CREATE TYPE string_list IS TABLE OF nvarchar2(32767)
      • CREATE TYPE number_list IS TABLE OF number
      • CREATE TYPE float_list IS TABLE OF float
      • CREATE TYPE date_list IS TABLE OF date
      • CREATE TYPE boolean_list IS TABLE OF boolean
      • CREATE TYPE timestamp_list IS TABLE OF timestamp
  2. Optional: If you have already created collection types from the previous step with a different name, or if any of the names conflict with any other collection types in your Oracle database, you can set a registry key on the CommServe computer instead.
    1. Open the Registry Editor and go to CommVault > Galaxy > Instance > CustomReportsEngine.
    2. Right-click CustomReportsEngine and select New > String Value.
    3. In the Name box, enter any of the following collection type names, double-click the Name, and then enter the associated value in the Value data box:

      Value Name

      Value Data

      ORACLE_STRING_TYPE

      string_list

      ORACLE_NUMBER_TYPE

      number_list

      ORACLE_FLOAT_TYPE

      float_list

      ORACLE_DATE_TYPE

      date_list

      ORACLE_BOOLEAN_TYPE

      boolean_list

      ORACLE_TIMESTAMP_TYPE

      timestamp_list

What to Do Next

 

 

Last modified: 12/13/2017 2:57:58 PM