SQL Reference Guide > SQL Reference Guide > SQL Statements > EXECUTE PROCEDURE > Positional Parameters Sample Syntax
Was this helpful?
Positional Parameters Sample Syntax
Here are two samples of procedure invocation with and without positional parameters.
The first example shows a mixture of positional parameters and named parameters:
EXECUTE PROCEDURE proc1 (25, 'abc', :a, p8 = 19, p11 = 22);
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:
...FROM table1, view3, rpp2('pqr', 'xyz', table1.col4), ...
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.
Last modified date: 01/30/2023