Here are two samples of procedure invocation with and without positional parameters.

The first example shows a mixture of positional parameters and named parameters:

The third parameter value is a host variable. All positional parameters must precede all named parameters in a parameter list.

The second example shows a syntax fragment from a query containing the invocation of a table procedure:

All parameters in this query are specified using positional notation and the third value is a reference to a column from another FROM clause entry.