Database Package Parameters

Database package procedures and cursors can use input and output parameters. For example, in a CREDIT procedure, you could define the parameters Account Number and Amount. You create database package parameters on the Parameters tab of a database package procedure or cursor using the Add a Row or Insert a Row tools.

To view or edit a database package parameter's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:

Property

Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

Stereotype

Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.

Parent

Specifies the database package parent of the parameter. You can see the database package property sheet by clicking the Properties tool at the right of the field.

Data type

Data type of the parameter. You can use the Question Mark button to display the list of Standard Data Types.

Default Value

Default value of the parameter.

Parameter type

Type of the parameter.

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.