Positional notation is calling a stored procedure by simply passing parameter values and assuming that the values will be associated with parameters in the order of declaration. The first value passed is associated with the first parameter, the second value with the second parameter, and so forth.
Calling a stored procedure using positional notation.
Check_Source_For_Insert ('JSCHMOE',
'CALCULATE_GPA');
When using positional notation, the values must be passed to the stored procedure in the proper order. This requires that developers know the order of the parameters.
Named notation is calling a stored procedure by specifying both the parameter names and each parameter’s value.
Calling a procedure using named notation.
Check_Source_For_Insert (vOwner => 'JSCHMOE',
vObject => 'CALCULATE_GPA');
When using named notation, the parameters for a procedure can be specified in any order (after all, the developer knows which values are intended for which parameters). Obviously, the use of named notation requires that the developer knows the names of the parameters and specifies the parameter names in procedure calls.
