Book a Demo

Author Topic: Generation of DDL scripts for oracle not working  (Read 3339 times)

ksengineers

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Generation of DDL scripts for oracle not working
« on: May 21, 2010, 12:52:27 am »
Hallo,

i have recently moved from 7.5 to 8.0 (Build 856). I'm using the "Generate package DDL ..." functionality to create the ddl script for my oracle database schema.

With the new version of EA not only same object namings have change (e.g. for triggers and sequences)  but also the code that is generate for triggers is not valid any longer!?

Is there a possibility to customize the way the code is generated?

The problem is that the create statement for a trigger now ends with two semikolons instead of a semikolon and a slash.


Compare the output of version 7.5:
CREATE OR REPLACE TRIGGER SET_ALIASES_ID
BEFORE INSERT
ON ALIASES
FOR EACH ROW
BEGIN
  SELECT ALIASES_ID_SEQ.NEXTVAL
  INTO :NEW.ID
  FROM DUAL;
END;
/


to the output of version 8.0 Build 856:
CREATE OR REPLACE TRIGGER TRG_ALIASES_ID
      BEFORE INSERT
      ON ALIASES
      FOR EACH ROW
      BEGIN
            SELECT SEQ_ALIASES_ID.NEXTVAL
            INTO :NEW.ID
            FROM DUAL;
      END;
;


Any ideas?


Thanks,

Eric