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.

OMBRETRIEVE PACKAGE

Purpose

Prerequisites

Syntax

Parameters

retrievePackageCommand

QUOTED_STRING

getPropertiesClause

getPropertiesClause

getRelationalDependentsClause

getReferenceIconSetClause

propertyNameList

PACKAGE Object

See Also