[ https://issues.jboss.org/browse/TEIID-2558?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2558: --------------------------------------- I now have a somewhat working example for Oracle however there are several issues. The first is that using ad hoc create/drop is fairly expensive for oracle since it's creating a global table (and without a source sequence we have to use a random or other naming strategy). Second it implies that if the operation is transactional then any pending work will be committed prior to the ddl execution, which is not generally something we can allow unless we know that the session has been used in a read-only capacity. An autonomous transaction may help here. Or it may not even work https://forums.oracle.com/thread/1083417 Third the ojdbc6 driver has a bug that does not allow bulk inserts against temporary tables. on executeBatch I receive an ArrayIndexOutOfBoundsException and can find no similar occurrences online. This happens with using either of the on commit behaviors. -- 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