I do not like this trail and error principle.

Is the SQL syntax implemented in TEIID something custom?

I have red in the docs it would adhere to sql-92 syntax

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?