CREATE PACKAGE BODY

The CREATE PACKAGE BODY statement creates the body of a standalone package. A package is an encapsulated collection of related procedures, functions, and other program objects stored together in your database. A package specification declares these objects. A package body defines these objects.

Required privilege

CREATE PROCEDURE (if owner) or CREATE ANY PROCEDURE (if not owner)

SQL syntax

CREATE [OR REPLACE] PACKAGE BDOY [Owner.]PackageBody 
      {IS|AS} plsql_package_body

Parameters

The CREATE PACKAGE BODY statement has the parameters:

Parameter	Description
`OR REPLACE`	Specify `OR REPLACE` to recreate the package body if it already exists. Use this clause to change the body of an existing package without dropping and recreating it. When you change a package body, TimesTen recompiles it.
`PackageBody`	Name of the package body.
`IS\|AS`	Specify either `IS` or `AS` to declare the body of the function.
`plsql_package_body`	Specifies the package body which consists of PL/SQL subprograms.

Description

The CREATE PACKAGE BODY statement is not replicated.

When you create or replace a package body, the privileges granted on the package body remain the same. If you drop and re-create the object, the object privileges that were granted on the original object are revoked.