I wanted to create a native query procedure which support unlimited number of object type parameters.

According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metadata.html, the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name:

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

In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure.

Please add this feature to Teiid Designer.