OMBALTER PACKAGE

Purpose

Alter the Package by renaming it, and/or reset its properties, and/or adding/deleting/modifying the user types.

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

alterPackageCommand =  OMBALTER ( PACKAGE "QUOTED_STRING" ( "renameClause" 
          [ "alterPropertiesOrIconSetClause" ] [ 
          "alterRelationalDependentsClause" ] | "alterPropertiesOrIconSetClause"
           [ "alterRelationalDependentsClause" ] | 
          "alterRelationalDependentsClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  SET ( "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) | UNSET "unsetReferenceIconSetClause"
     alterRelationalDependentsClause =  ( ADD "addRelationalDependentClause" | 
          DELETE "deleteRelationalDependentClause" ) [ 
          "alterRelationalDependentsClause" ]
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     addRelationalDependentClause =  ( REFERENCE | REF ) ( TABLE | VIEW | 
          MATERIALIZED_VIEW | SEQUENCE | FUNCTION | PROCEDURE | PACKAGE ) 
          "QUOTED_STRING"
     deleteRelationalDependentClause =  ( 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

alterPackageCommand

This command modifies an existing Package.

QUOTED_STRING

Name of the existing Package in single quotes.

renameClause

Rename a Package.

alterPropertiesOrIconSetClause

Used to alter package properties or icon set.

alterRelationalDependentsClause

This clause adds or deletes referential dependencies to other relational objects.

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 

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

setReferenceIconSetClause

Used to set reference icon set.

unsetReferenceIconSetClause

Used to unset reference icon set associated with current package.

addRelationalDependentClause

This clause adds referential dependencies to other relational objects.

deleteRelationalDependentClause

This clause deletes 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 3-62 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.

OMBALTER PACKAGE

Purpose

Prerequisites

Syntax

Parameters

alterPackageCommand

QUOTED_STRING

renameClause

alterPropertiesOrIconSetClause

alterRelationalDependentsClause

setPropertiesClause

setPropertiesClause

setReferenceIconSetClause

unsetReferenceIconSetClause

addRelationalDependentClause

deleteRelationalDependentClause

propertyNameList

propertyValueList

propertyValue

PACKAGE Object

See Also