OMBCREATE PACKAGE

Purpose

To create a Package.

Prerequisites

Should be in the context of a Oracle Module or Transformation Module.

A Transformation Module may be WB_CUSTOM_TRANS for Public Transformations.

WB_CUSTOM_TRANS may by modified by an administrator.

WB_CUSTOM_TRANS is not dependent on any project.

Syntax

createPackageCommand =  OMBCREATE ( PACKAGE "QUOTED_STRING" ( [ SET ( 
          "setPropertiesClause" [ SET "setReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) ] ) { ADD "addRelationalDependentClause"
           } )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addRelationalDependentClause =  ( REFERENCE | REF ) ( TABLE | VIEW | 
          MATERIALIZED_VIEW | SEQUENCE | FUNCTION | PROCEDURE | PACKAGE ) 
          "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createPackageCommand

This command creates a Package

QUOTED_STRING

Name of the Package to be created.

setPropertiesClause

Used to set properties (core, user-defined) for packages. Valid properties are shown below:

setPropertiesClause

Basic properties for PACKAGE: 

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

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

setReferenceIconSetClause

Set reference icon set to this

addRelationalDependentClause

This clause adds referential dependencies to other relational objects.

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values.

propertyValue

Value of a property.

PACKAGE Object

Table 8-64 PACKAGE Object

Property Type Choices Min Max Default Description

AUTHID

STRING

, Current_User, Definer

none

none

empty string

Generate the package with selected AUTHID option. Function will be executed with the permissions defined by the AUTHID clause rather than the function owner's permissions.

DEPLOYABLE

BOOLEAN

true, false

none

none

true

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

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

See Also

OMBCREATE

OMBALTER PACKAGE

OMBDROP PACKAGE