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 Affects Versions: 7.1.1 Reporter: Boris Belovic Assignee: Barry LaFond Fix For: 7.1.1 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

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 Affects Versions: 7.1.1 Reporter: Boris Belovic Assignee: Barry LaFond Priority: Blocker Fix For: 7.1.1 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