2 Replies Latest reply: Feb 20, 2013 4:44 AM by David Last-Oracle RSS

    enable trigger statement missing semicolon

      in the (Oracle) trigger properties we selected state="Enable".
      When generating DDL, a corresponding "alter trigger xyz enable" code is generated.
      However, this code does not containing the closing somicolon.
      Trying to run this code (in SQL Devloper) generates error.
      Once having specified state="Enable" it is also not possible to remove the setting,
      only switching between Enabble / Disable is saved.
      Is this a (known) bug?