DB Package Sub-objects

The following categories are located in the Root > Script > Objects category:

  • DB Package Procedure

  • DB Package Variable

  • DB Package Type

  • DB Package Cursor

  • DB Package Exception

  • DB Package Pragma

Each contains many of 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:

  • Add

  • ReversedQueries

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

DBProcedure Body

[database package procedures only] Specifies a template for defining the body of the package procedure in the Definition tab of its property sheet.

Example (Oracle 10g):

begin
end

ParameterTypes

[database package procedures and cursors only] Specifies the available types for procedures or cursors.

Example (Oracle 10g: procedure):

in
in nocopy
in out
in out nocopy
out
out nocopy