Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

11.9. Variable Argument Support

Instead of using just an IN parameter, the last non optional parameter can be declared VARIADIC to indicate that it can be repeated 0 or more times when the procedure is called positionally. Section A.7, “Productions”.

Example 11.5. Example:Vararg procedure

CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer) returns (x string);