[teiid-issues] [JBoss JIRA] (TEIID-4644) anonymous block dynamic issues

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4644:
-------------------------------------

             Summary: anonymous block dynamic issues
                 Key: TEIID-4644
                 URL: https://issues.jboss.org/browse/TEIID-4644
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins


Using execute immediate 'begin ... end'

Has several issues.  First any variable references such as rowcount will be rewritten in the outer scope and not evaluated as part of the procedure.  Also the anonymous block cannot be used with targeting an into as the statement we create is insert into select ... from (begin ... end) .. - which is not valid, however the exception message does not make this clear.

So we either need to improve these issues or disallow using anonymous blocks as dynamic sql.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)