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 QUEUE_TABLE

Purpose

To create a Queue Table.

Prerequisites

Should be in the context of an Oracle Module. The Object Type can exist in any Oracle Module.

Syntax

createQTCommand =  OMBCREATE ( QUEUE_TABLE "QUOTED_STRING" [ SET 
          "setQTPropertiesClause" ] )
     setQTPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createQTCommand

Creates a Queue Table with the given name.

setQTPropertiesClause

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

getQTPropertiesClause

Basic properties for QUEUE_TABLE: 

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

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

Name: PAYLOAD_TYPE
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Object Type for the Queue Table. This has to be the name of an Object Type  (OBJECT_TYPE) existing in any Oracle Module.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

QUEUE_TABLE Object

Table 9-52 QUEUE_TABLE Object

Property Type Choices Min Max Default Description

DEPLOYABLE

BOOLEAN

true, false

none

none

true

Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true.

GENERATE_QUEUE_TABLE

BOOLEAN

true, false

none

none

true

Generate code to create the queue table that will persist the messages of this Advanced Queue.

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

TABLESPACE

STRING(30)

none

none

none

empty string