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.
In addition to the standard Name, Code, and Comment, a database package parameter has the following properties:
|
Property |
Description |
|---|---|
|
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. |