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

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

    cshong Newbie

      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?