[
https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-3208:
----------------------------------------
Designer currently exposes the *VARARGS* boolean property for a procedure. For archive
VDBs (and models), the procedure's metadata should behave as if the last paramater is
VARIADIC.
However, importing/exporting Dynamic VDBs containing VARIADIC parameter will set the
VARARGS to true. This will require modify the DDL importer to detect VARIADIC and set the
VARARGS value and export DDL by converting back.
Support virtual / foreign procedure with VARIADIC parameter
-----------------------------------------------------------
Key: TEIIDDES-3208
URL:
https://issues.jboss.org/browse/TEIIDDES-3208
Project: Teiid Designer
Issue Type: Enhancement
Affects Versions: 11.1
Environment: Operating system: Windows 10.
Reporter: SHI HONG CHIN
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_Metad..., the
following SQL statement define a procedure with VARIADIC parameter by adding the word
"VARIADIC" before the parameter name:
{code:java}
CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer)
RETURNS (x string);
{code}
In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure.
Please add this feature to Teiid Designer.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)