[
https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5725:
---------------------------------------
You have two options currently. A temporary table:
insert into #temp select a,b from table where table.c = 0;
declare integer b = (select b from #temp);
...
Obviously this can work when you have more than one row.
The other option is an array:
declare integer[] val = (select (a,b) from table where table.c = 0);
then use array indexing to access a or b with val[1] or val[2]
Please improve documentation on definition of stored procedures,
virtual functions and virtual procedures
---------------------------------------------------------------------------------------------------------
Key: TEIID-5725
URL:
https://issues.jboss.org/browse/TEIID-5725
Project: Teiid
Issue Type: Enhancement
Reporter: Christoph John
Assignee: Steven Hawkins
Priority: Critical
I refer to the discussion with Ramesh in
https://developer.jboss.org/message/989048#989048 and would like to ask for a more
detailed explanation on how to write virtual procedures and functions.
-Especially, how are OUT and INOUT params set and how can they be obtained via odata.
- How is the return value of a virtual function set?
- How are collections and arrays of collections returned?
--
This message was sent by Atlassian Jira
(v7.12.1#712002)