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%];
Parent topic: Script/Objects Category