Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#50 Compound Trigger fail to extract with built-in DDL generator

V1.21RC3
open
nobody
General (41)
5
2010-02-18
2010-02-18
randolf_geist
No

The new compound triggers introduced with 11.1 are not supported at present by the built-in DDL generator code. An exception will be raised when attempting to extract such trigger code.

A possible workaround is to use the "Use DBMS_METADATA for DDL generation" option

Discussion

  • Thorsten Jung
    Thorsten Jung
    2010-02-19

    I've tried the workaround but it doesn't work.
    Instead of the SQLTools++ error i get the ORACLE-error ORA 31603 (Objekt "TIC_EM_TM_SCHADEN" vom Typ TRIGGER im Schema "ECHO" nicht gefunden) but the trigger ist created correct and is still working.

    Greetings

    Thorsten

     
  • Thorsten Jung
    Thorsten Jung
    2010-02-19

    Hello, here some actual news:
    the error occurs using the development (database)instance.
    On the test-instance, which runs on an own db-server (same ORACLE-version!), the workaround works.
    So there must be a difference in the installation of the instances or db-server, which i do not now.
    I've got to ask my colleague, who has made the installation.
    Greetings

    Thorsten