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

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

OMBCREATE PLSQL_TABLE_TYPE

Purpose

To create a PLSQL Table Type.

Prerequisites

Should be in the context of a Package.

Syntax

createPlSqlTableTypeCommand =  OMBCREATE ( PLSQL_TABLE_TYPE "QUOTED_STRING"
           SET "setPropertiesClause" )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createPlSqlTableTypeCommand

Creates a PL/SQL Table Type with the given name.

setPropertiesClause

Sets properties (core, logical, physical, user-defined) for Table Type Valid properties are shown below:

getPropertiesClause

Basic properties for PLSQL_TABLE_TYPE: 

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

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

Name: RETURN_TYPE
Type: STRING(20)
Valid Values: NUMBER, VARCHAR2, VARCHAR, DATE, FLOAT
Default: Empty string
Return type of the Table Type. This can be a scalar type or a PLSQL Record Type.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

PLSQL_TABLE_TYPE Object

Table 9-1 PLSQL_TABLE_TYPE Object

Property Type Choices Min Max Default Description

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.


PLSQL_TABLE_TYPE Object

Table 9-2 PLSQL_TABLE_TYPE Object

Property Type Choices Min Max Default Description

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.