5 Replies Latest reply on Jun 28, 2018 8:12 AM by shawkins

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

cshong Jun 25, 2018 9:13 PM

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?

1. Re: In Teiid Designer, how to create a VARIADIC parameter for a procedure?

shawkins Jun 26, 2018 8:41 PM (in response to cshong)

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.
Actions
2. Re: In Teiid Designer, how to create a VARIADIC parameter for a procedure?

cshong Jun 26, 2018 9:55 PM (in response to shawkins)

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.
Actions
3. Re: In Teiid Designer, how to create a VARIADIC parameter for a procedure?

shawkins Jun 27, 2018 7:30 AM (in response to cshong)

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?
Actions
4. Re: In Teiid Designer, how to create a VARIADIC parameter for a procedure?

cshong Jun 27, 2018 9:17 PM (in response to shawkins)

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.
Actions
5. Re: In Teiid Designer, how to create a VARIADIC parameter for a procedure?

shawkins Jun 28, 2018 8:12 AM (in response to cshong)

> 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.
Actions

Go to original post