[teiid-issues] [JBoss JIRA] (TEIID-2614) Allow anonymous procedure blocks

Tue Aug 6 14:14:26 EDT 2013

     [ https://issues.jboss.org/browse/TEIID-2614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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