Steven Hawkins created TEIID-5773: ------------------------------------- Summary: Allow for generated_key retrieval at a session level Key: TEIID-5773 URL: https://issues.jboss.org/browse/TEIID-5773 Project: Teiid Issue Type: Sub-task Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.3 The docs suggest that generated_key should be called in a procedure. However calling outside of a procedure will currently return no values as the keys are associated with the executing command context only. Ideally from a connection the user should be able to do: insert into ...; select generated_key() ...; In separate statements and still retrieve the key value. The workaround is to use an anonymous procedure block: begin insert into ...; select generated_key() ...; end -- This message was sent by Atlassian Jira (v7.12.1#712002)