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).
Usage with TimesTen Scaleout
This statement is supported with TimesTen Scaleout.
SQL Syntax
CREATE [OR REPLACE] PACKAGE BODY [Owner.]PackageBody {IS|AS} plsql_package_body
Parameters
Parameter | Description |
---|---|
|
Specify |
|
Name of the package body. |
|
Specify either |
|
Specifies the package body which consists of PL/SQL subprograms. |
Description
In a replicated environment, the CREATE PACKAGE BODY
statement is not replicated. For more information, see Creating a New PL/SQL Object in an Existing Active Standby Pair and Adding a PL/SQL Object to an Existing Classic Replication Scheme in the Oracle TimesTen In-Memory Database Replication
Guide.
When you create or replace a package body, the privileges granted on the package body remain the same. If you drop and recreate the object, the object privileges that were granted on the original object are revoked.