Database package procedures and cursors can use input and output parameters.
For more inofrmation, see Database package procedures and Database package cursors.
For example, in a CREDIT procedure, you could define the parameters Account Number and Amount.
Parameters have the following properties:
|
Property |
Description |
|---|---|
|
Name |
The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users. |
|
Code |
The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces. |
|
Comment |
Additional information about the parameter. |
|
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. |