Compound Trigger fail to extract with built-in DDL generator
Brought to you by:
randolf_geist
Menu
▾
▴
#50 Compound Trigger fail to extract with built-in DDL generator
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
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
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