[
https://issues.jboss.org/browse/TEIID-2614?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2614.
-----------------------------------
Resolution: Done
Allowing the parser to treat a compound statement as a valid user command.
In parameters are supported with prepared/callable statement parameters. out is not yet
supported as the driver logic would have to change to collect the out registrations - the
workaround would be to use session variables. Return is not supported as well. A single
result set may be returned if any of the statements returns a result set. As per the
standard validation logic all returnable results must match or a validation exception will
be thrown.
Also since TEIID-2103 in 8.1 it has been optional for designer procedures to be prefixed
with CREATE VIRTUAL PROCEDURE. This change goes further so that the expected string form
no longer includes that declaration - which is only a concern if the vdb would be deployed
on a pre-8.1 server.
Allow anonymous procedure blocks
--------------------------------
Key: TEIID-2614
URL:
https://issues.jboss.org/browse/TEIID-2614
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.5
In some cases it is beneficial to submit a block of sql for processing rather than
performing partial result processing in the client.
Given that we are effectively using anon blocks internally, we should expose this feature
for general use.
--
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