DB Package Sub-objects

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

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

Item

Description

[Common items]

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

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