Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBRETRIEVE ACTIVITY_TEMPLATE

Purpose

To retrieve the details of an activity template.

Prerequisites

Should be in the context of an Activity Template Folder.

Syntax

parseRetrieveTemplateCommand =  OMBRETRIEVE ACTIVITY_TEMPLATE 
          "QUOTED_STRING" ( "getParameterPropertiesClause" | 
          "getTemplatePropertiesClause" )
     getParameterPropertiesClause =  PARAMETER "QUOTED_STRING" GET PROPERTIES 
          "propertyKeyList"
     getTemplatePropertiesClause =  ( GET ( ( PROPERTIES "propertyKeyList" ) | 
          PARAMETERS | ( ( REFERENCE | REF ) [ "getReferenceIconSetClause" ] ) )
           )
     propertyKeyList =  "(" "propertyKey" { "," "propertyKey" } ")"
     getReferenceIconSetClause =  ICONSET
     propertyKey =  "UNQUOTED_STRING"

Parameters

parseRetrieveTemplateCommand

This command retrieves the details of an activity template.

getParameterPropertiesClause

Get the values of the specified properties of the activity template.

getParameterPropertiesClause

Description of the Activity Template Core properties for Activity Parameter: 

Name: DATATYPE
Type: STRING
Valid Values: INTEGER, FLOAT, DATE, STRING, BOOLEAN
Default: STRING 
Sets the datatype of a Parameter 


Name: DIRECTION
Type: STRING
Valid Values: IN
Default: IN 
Sets the direction of a Parameter 


Name: DEFAULT_VALUE
Type: STRING
Valid Values: Examples '123', '123.456', 'Jan-08-2003', 'I am String', 'true'
Default: Empty string 
Sets the default value of a Parameter

getTemplatePropertiesClause

Get the values of the specified properties of the parameter.

getTemplatePropertiesClause

Basic properties for ACTIVITY_TEMPLATE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the Activity Template 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the Activity Template

propertyKeyList

The list of property keys.

getReferenceIconSetClause

Retrieve the icon set referenced by this activity template.

propertyKey

A property key for an object.

PARAMETER Object

Table 17-1 PARAMETER Object

Property Type Choices Min Max Default Description

META_IMPORT_BYTES_PER_CHAR

NUMBER

none

none

none

1

 

META_IMPORT_CHARSET

STRING(45)

none

none

none

empty string

 

META_IMPORT_USE_CHAR_SEMANTICS

BOOLEAN

true, false

none

none

false