Menu

#92 Oracle DDL is missing blank line and slash between triggers

v1.0 (example)
closed
None
5
2014-04-06
2014-03-21
No

If the ER diagram has multiple triggers and the database is Oracle the generated DDL does not contain a blank line and a slash.

Generates:

CREATE TRIGGER TRIGGER1 ...

END;

CREATE TRIGGER TRIGGER2

END;

Needs to generate,
CREATE TRIGGER TRIGGER1 ...

END;

/

CREATE TRIGGER TRIGGER2

END;

Discussion

  • Daryl Gerlach

    Daryl Gerlach - 2014-03-21

    There should also be a trailing slash. Generated output should be

    CREATE TRIGGER TRIGGER1 ...
    END;

    /

    CREATE TRIGGER TRIGGER2
    END;

    /

     
  • Hiroyuki Nakajima

    Thank you so much for your report !

     
  • Hiroyuki Nakajima

    • status: open --> closed
    • assigned_to: Hiroyuki Nakajima
     

Log in to post a comment.