| 27. 14. 1. Defining Formal Parameters |
|
|
A parameter is a value that you can pass from a block of statements to a function. |
The Syntax for Defining a Parameter |
|
parameter_name [MODE] parameter_type [:= value | DEFAULT value]
|
|
parameter_name is the name you assign to the parameter |
parameter_type is the variable type you assign. |
The optional MODE statement gives you complete control over your incoming parameters. |
The simplest parameter can be coded as |
|
|
p_squared is the parameter_name, and NUMBER is the parameter_type. |
You can add a %TYPE after the parameter. |
%TYPE will pick up the field type from the table. |
|
(p_emptype employee.pay_type%TYPE)
|
|
Types of modes. |
| MODE | Handling of Parameter | | IN | Read-only | | OUT | Write-only | | IN OUT | Read or write |
|