Chapter 3 DBMS Resource File Reference


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

 


Copyright (C) 2008. Sybase Inc. All rights reserved.