[ https://issues.jboss.org/browse/TEIID-2644?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2644: --------------------------------------- An overview of what works and doesn't work currently: Working: An oracle stored function returning a ref cursor as the result set An oracle stored function returning a table type, but it looks to using the native-query form of SELECT * FROM TABLE(func(params...)) - we could also look at generating this form of the sql as the native-query logic is not yet good for handling vararg procedrues. Not working: An oracle stored procedure/function with an out parameter ref cursor as the result set (the driver for this issue). A stored procedure with an out parameter of a table type as the result set. A stored procedure with an expression as a parameter value (from the associated forum posting). Usability issue abound though with ref cursors in general as they are untyped. All the import logic will see when used as an out parameter is a column typed as OTHER. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira