[teiid-issues] [JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-5725 at 4/22/19 11:11 AM: ----------------------------------------------------------------- OData access is quite different than just JDBC / pg access. OData treats INOUTS as just IN, and OUT is ignored. So they can be present in the Teiid metadata, just not utilized over OData. A procedure with a result set: create virtual procedure rs () returns table (a string, b string) ... Will return a collection of a complex type containing a, b. For example in json {code} [{a='aval1', b='bval1'}, {a='aval2', b='bval2'}, ...] {code} A procedure with an array result: create virtual procedure rs () returns string[] ... Will return a collection of a string simple type. For example in json {code} ['val1', 'val2', ...] {code} The usage of something multi-dimensional like string[][] in odata is not currently supported. Start with http://teiid.github.io/teiid-documents/master/content/reference/Procedure... And see the grammar as well: http://teiid.github.io/teiid-documents/master/content/reference/BNF_for_S... Yes, the select into construct is only used for tables in Teiid - it's just a different form of "insert into tbl select ..."; was (Author: shawkins): OData access is quite different than just JDBC / pg access. OData treats INOUTS as just IN, and OUT is ignored. So they can be present in the Teiid metadata, just not utilized over OData. A procedure with a result set: create virtual procedure rs () returns table (a string, b string) ... Will return a collection of a complex type containing a, b. For example in json [{a='aval1', b='bval1'}, {a='aval2', b='bval2'}, ...] A procedure with an array result: create virtual procedure rs () returns string[] ... Will return a collection of a string simple type. For example in json ['val1', 'val2', ...] The usage of something multi-dimensional like string[][] in odata is not currently supported. Start with http://teiid.github.io/teiid-documents/master/content/reference/Procedure... And see the grammar as well: http://teiid.github.io/teiid-documents/master/content/reference/BNF_for_S... Yes, the select into construct is only used for tables in Teiid - it's just a different form of "insert into tbl select ..."; -- This message was sent by Atlassian Jira (v7.12.1#712002)