DB Package

Chapter 3 DBMS Resource File Reference

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%];