Friday, 25 May 2012

What are the different methods for passing parameters to a procedure? | PL SQL

 There are following three different methods to pass values to a procedure:
 Positional— Refers to a method in which actual parameters of a procedure are passed in the same order as the formal parameters
 Named— Refers to a method in which actual parameters of a procedure are passed in any arbitrary order but are associated with their corresponding formal parameters
Combination— Refers to a method in which some parameters are passed as positional and some are passed as named parameters.