I have not found the relevant section in the documentation. Could you please add a link?

Furthermore, as far as I understand your comment, simply adding OPTIONS(UPDATECOUNT '0') will force the procedure to become a function? a function also always needs to have a return value. Is this also considered?

I assume INOUT parameters are ignored as return values?

Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA functions, and actions if procedure has side effects ----------------------------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-5729 URL: https://issues.jboss.org/browse/TEIID-5729 Project: Teiid Issue Type: Enhancement Components: OData Reporter: Christoph John Assignee: Steven Hawkins Priority: Major Fix For: 12.3 This is a follow up regarding https://issues.jboss.org/browse/TEIID-5725 As discussed there, Teiid currently does not map virtual procedures and functions to odata functions and procedures according to the notion of "side effect free" Please introduce a mechanism to allow for a mapping according to adequate odata semantics.