The Initial Value property specifies the default value for the parameter. This value is used unless it is overridden on the command line or the Runtime Parameter Form.
Applies to |
Parameters | ||||||||||||||
Values |
Any value appropriate for the Datatype of the parameter. Cannot exceed 1K in length. If left blank, the parameter has no default value. | ||||||||||||||
Default |
| ||||||||||||||
Required/Optional |
Optional |
Initial Value is validated according to the Datatype and Width of the parameter. In addition, Initial Value is validated against the Input Mask property.
If no value is specified and the parameter is referenced in SQL or PL/SQL, a null is used to parse the SQL or PL/SQL. If a null causes the SQL or PL/SQL construct to parse incorrectly, an error will be raised.
Copyright © 1984, 2005, Oracle. All rights reserved.