[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-792) add support for in/out out return params

[ https://issues.jboss.org/browse/TEIIDDES-792?page=com.atlassian.jira.plug... ] Steven Hawkins commented on TEIIDDES-792: ----------------------------------------- Changed the code to allow inout/out/return parameters for virtual procedures. The restrictions were removed that forced virtual procs to have resultsets. Also changed the default sql for generated procedures to not wrap with a select and to use named parameters, e.g. instead of create virtual procedure begin select * from (exec foo(param1, param2)) as proc end we'll get create virtual procedure begin exec foo(param1=>param1, param2=>param2) end this allows for proper handling of out/inout/return assignment. The docs and the test scripts will need updated appropriately. The code for text based metadata import and export was not updated. That code still assumes that procedures have result sets. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira