DB Package

The DB Package category is located in the Root > Script > Objects category, and can contain the following items that define how database packages are modeled for your DBMS.

Item	Description
[Common items]	The following common object items may be defined for database packages: AfterCreate, AfterDrop, AfterModify BeforeCreate, BeforeDrop, BeforeModify Create, Drop Enable, EnableSynonym Maxlen ModifiableAttributes Permission ReversedQueries, ReversedStatements SqlAttrQuery, SqlListQuery, SqlPermQuery For a description of each of these common items, see Common object items.
Authorizations	Specifies a list of those users able to invoke database packages.
CreateBody	Specifies a template for defining the body of the database package. This statement is used in the extension statement AfterCreate. Example (Oracle 10g): create [or replace ]package body [%QUALIFIER%]%DBPACKAGE% [.O:[as][is]][%IsPragma% ? pragma serially_reusable] %DBPACKAGEBODY% [begin %DBPACKAGEINIT% ]end[ %DBPACKAGE%];

Item

Description

[Common items]

The following common object items may be defined for database packages:

AfterCreate, AfterDrop, AfterModify
BeforeCreate, BeforeDrop, BeforeModify
Create, Drop
Enable, EnableSynonym
Maxlen
ModifiableAttributes
Permission
ReversedQueries, ReversedStatements
SqlAttrQuery, SqlListQuery, SqlPermQuery

For a description of each of these common items, see Common object items.

Authorizations

Specifies a list of those users able to invoke database packages.

CreateBody

Specifies a template for defining the body of the database package. This statement is used in the extension statement AfterCreate.

Example (Oracle 10g):

create [or replace ]package body [%QUALIFIER%]%DBPACKAGE% [.O:[as][is]][%IsPragma% ? pragma serially_reusable]
 %DBPACKAGEBODY%
[begin
 %DBPACKAGEINIT%
]end[ %DBPACKAGE%];