[teiid-designer-issues] [JBoss JIRA] Created: (TEIIDDES-729) Teiid designer generates SQL*Plus specific statements

Teiid designer generates SQL*Plus specific statements ----------------------------------------------------- Key: TEIIDDES-729 URL: https://jira.jboss.org/browse/TEIIDDES-729 Project: Teiid Designer Issue Type: Bug Components: Import/Export Reporter: Boris Belovic When generating DDL files for Oracle database, Teiid designer adds Oracle SQL*Plus specific statements into this DDL file. From discussion on #metamatrix channel turned out that these statements are specific to SQL*Plus tooling. With other tools (for example Ant's sql task) these commands cause failures and the DDL file doesn't execute correctly. For example following file: CREATE TABLE MVCloneMaterializedTable ( name VARCHAR2(255), surname VARCHAR2(255), label VARCHAR2(255) ); SET DEFINE OFF SET DEFINE ON -- Uncomment the following line for use of the logging facility --spool off commit; when executed through Ant's sql task will fail with this error: Failed to execute: SET DEFINE OFF SET DEFINE ON commit -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira