Parameter binding
- By (Index|position): List the values in the order the arguments appear in the procedure declaration.
-- With the following procedure signature Sal_raise(Emp_id number, Sal_incr number);
Sal_raise(7369, 500);
-- 7369 is for emp_id
-- 500 is for the increase in salary
- By Name: Specify the argument names and corresponding values, in any order.
Sal_raise(Sal_incr=>500, Emp_id=>7369);
- A mix of the two
Sal_raise(7369, Sal_incr=>500);