Details
-
Bug
-
Resolution: Done
-
Blocker
-
7.1.1
-
None
Description
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
Attachments
Issue Links
- relates to
-
JBDS-1432 Teiid designer generates SQL*Plus specific statements
- Closed