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


Powered by ComboStrap