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.

See Also

OMBALTER

OMBCREATE PACKAGE

OMBDROP PACKAGE