Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-729

Teiid designer generates SQL*Plus specific statements

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 7.1.1
    • 7.1.1
    • Import/Export
    • 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

          Activity

            People

              blafond Barry LaFond
              bbelovic_jira Boris Belovic (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: