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

    enable trigger statement missing semicolon

    Jan-Peter
      Hi,
      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?
      Regards,
      Jan-Peter