>Another thing to consider is if you even need an atomic block. Are you worried about a competing update to NutritionGoal in between the select and update?

> Yes that is the workaround in this case if you want it as an action. More than likely though we'd want the semantics of "side effect free" to be represented rather than documenting this as a corner case. Can you log an issue about this?

>You could combine both of the selects, and you may find it easier to read using a loop rather than a lot of scalar subqueries:

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 Components: Documentation 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?