OMBRETRIEVE PACKAGE

Purpose

Retrieve details of the 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 or WB_PREDEFINED_TRANS for Predefined Transformations.

WB_CUSTOM_TRANS may by modified by an administrator. WB_PREDEFINED_TRANS may not be modified.

WB_CUSTOM_TRANS and WB_PREDEFINED_TRANS are not dependent on any project.

Syntax

retrievePackageCommand =  OMBRETRIEVE PACKAGE "QUOTED_STRING" ( 
          "getPropertiesClause" | "getRelationalDependentsClause" | 
          "getReferenceIconSetClause" )
     getPropertiesClause =  GET PROPERTIES "(" "propertyNameList" ")"
     getRelationalDependentsClause =  GET ( REF | REFERENCE ) ( TABLES | VIEWS |
           MATERIALIZED_VIEWS | SEQUENCES | FUNCTIONS | PROCEDURES | PACKAGES )
     getReferenceIconSetClause =  GET ( REF | REFERENCE ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrievePackageCommand

This command retrieves the details of a Package

QUOTED_STRING

Name of the existing Package or path to the Package.

getPropertiesClause

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

getPropertiesClause

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

Name: PACKAGE_SPEC
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: Empty string
Retrieves the Package Spec of Imported Package 

Name: PACKAGE_BODY
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: Empty string
Retrieves the Package Body of Imported Package 

Name: IS_IMPORTED
Type: BOOLEAN
Valid Values: Any valid character string in supported character set.
Default: Empty string
Retrieves 'true' if the Package is Imported otherwise 'false'

getRelationalDependentsClause

This clause retrieves referential dependencies to other relational objects.

getReferenceIconSetClause

Used to get package reference icon set.

propertyNameList

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

PACKAGE Object

Table 20-4 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

OMBRETRIEVE