[
https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu...
]
SHI HONG CHIN edited comment on TEIIDDES-3208 at 6/26/18 9:35 PM:
------------------------------------------------------------------
For testing, I created another view model, and created another procedure in the view model
to execute the SampleNativeQueryProc1 procedure which you see in the screenshots in
comments above.
!procedure extra param error.png|thumbnail!
As you can see, there is an error telling me extra parameters passed to the procedure.
This error will occur, regardless of whether I set the "function" property of
SampleNativeQueryProc1 to true or false. Even if I set the "function" property
to true, and the VARARGS to true (VARARGS property will only appear if I set
"function" property to true), the error still occur.
was (Author: cshong):
For testing, I created another view model, and created another procedure in the view model
to execute the SampleNativeQueryProc1 procedure which you see in the screenshots in
comments above.
!procedure extra param error.png|thumbnail!
As you can see, there is an error telling me extra parameters passed to the procedure.
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
Assignee: Barry LaFond
Fix For: 11.2
Attachments: nativeprocparams.png, procedure extra param error.png, procedures
with no VARARGS.png
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)