PLSQL - Procedure

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);

Documentation / Reference

• https://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_pc.htm#1007684