When you create a parameter, you specify its name, datatype, length, and default value.
To create a parameter:
Parameter Data Type |
Set to CHAR, NUMBER, or DATE. |
Parameter Initial Value |
The default value of the parameter. Must be compatible with the parameter data type and length. |
Length |
The maximum number of characters the parameter can store. Length is only valid for CHAR parameters, which can be up to 64K. NUMBER parameters default to 23 bytes and DATE parameters default to 7 bytes. |
Name |
The internal name of the parameter. |