In Teiid Designer, how to create a VARIADIC parameter for a procedure?

[cshong]

http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metadata.html#_create_procedure_function

I had read the above reference. In Teiid Designer, I had created a source model, and a custom procedure inside the source model. For that procedure, I would like to create a VARIADIC parameter which can be repeated 0 or more times when the procedure is called. But, I do not know how to define a VARIADIC parameter in Teiid Designer. For a procedure parameter, when I try to choose a direction, I was only given the choices of "IN", "OUT", "INOUT", "RETURN", "UNKNOWN".

Can anybody here give me instructions on how to define a VARIADIC parameter in a procedure in Teiid Designer?

[shawkins]

See [TEIIDDES-3208] Support virtual / foreign procedure with VARIADIC parameter - JBoss Issue Tracker

It looks like there should be a VARARGS property on the procedure that will make the last parameter VARIADIC.

[cshong]

However, no VARARGS property for the procedure, if I did not set the "function" property to true.

VARARGS property will only appear, if I set the "function" property to true. But, even if I set the function property to true and the VARARGS to true, the procedure still cannot be executed from another procedure in another view model. If I create another procedure in another view model to execute this procedure, there will be an error telling me that extra parameters passed to the procedure.

[shawkins]

Sorry cshong that is probably why the issue is still open as it looks like the designer support is very incomplete - for functions only, but without resolving support.  Can you leave a comment on the issue about where things stand?

[cshong]

Sorry, I don't understand, what you mean by "where things stand"? In the issue, I did leave comment to tell developers about no VARARGS property in procedure, and the error occurred when defining query to execute the procedure in another procedure in another view model.

[shawkins]

> Sorry, I don't understand, what you mean by "where things stand"?

I meant make comments on the issue about the behavior you are seeing.  It looks like that has been captured.

I reviewed the code with blafond and concluded there is no Designer model support that is possible for procedure variadic parameters - they can only be specified in DDL.  If you are a JDV customer this should be raised as a support case otherwise you can log a Teiid issue - but that will only be fixed in the later 10.x and 11.x releases.