[teiid-issues] [JBoss JIRA] Work started: (TEIID-1237) Stored procedures should allow for better use of inout/out/return values

Stored procedures should allow for better use of inout/out/return values ------------------------------------------------------------------------ Key: TEIID-1237 URL: https://jira.jboss.org/browse/TEIID-1237 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.2 Teiid stored procedure command or assignment statements do not typically make use of inout/out/return values (the exception is if a resultset is not returned). It would be better to allow variables to be used in inout/out positions to capture the out values. e.g. instead of call proc(1) just implicitly creating the result set to return, a = call proc(1, b) would also assign the return value to a and would set an out value to b.