Book a Demo

Author Topic: Oracle Triggers Generate In Spite of DDL Generatio  (Read 2181 times)

Jeff Odell

  • EA User
  • **
  • Posts: 99
  • Karma: +0/-0
    • View Profile
Oracle Triggers Generate In Spite of DDL Generatio
« on: February 16, 2004, 02:48:12 pm »
When generating DDL for Oracle, I'm using the autoincrement function on primary key columns.  When generating DDL, I'd like the Oracle Sequence DDL to be built, but no trigger code.  The standard where I'm working is to use stored procs to increment and insert the sequence.

In the generate DDL dialog, I deselect the generate trigger check box, but the triggeres for the sequence are generated anyway.

I reported this, but I'm guessing that setting was for triggers defined in the model by the user.  It seems like itdoesn't apply to the trigger generated by the autoincrement feature.  I'd like it to, but in the mean time does anyone have a workaround?

Thanks -

Jeff Odell