8. SQL Statements : EXECUTE PROCEDURE : Positional Parameters Sample Syntax
 
Share this page                  
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.