Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.2.0, extension/ezoracle 1.8.2
-
None
Description
The upgrade script from 3.10.0 to 4.0.0 (in ezoracle 1.8) and from 4.0.0 to 4.1.0 (in ezroracle 2.0) contain some erroneous triggers/seqeunces:
CREATE SEQUENCE s_urlwildcard; -- should be ezurlwildcard_id_tr CREATE OR REPLACE TRIGGER ezurlwildcard_tr BEFORE INSERT ON ezurlwildcard FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_urlwildcard.nextval INTO :new.id FROM dual; END;
-- bad sequence name, trigger name and bad table! CREATE SEQUENCE s_ezcobj_state; CREATE OR REPLACE TRIGGER ezcobj_state_tr BEFORE INSERT ON ezurlwildcard FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_ezcobj_state.nextval INTO :new.id FROM dual; END; / -- bad sequence name and trigger name CREATE SEQUENCE s_ezcobj_state_group; CREATE OR REPLACE TRIGGER ezcobj_state_group_tr BEFORE INSERT ON ezcobj_state_group FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_ezcobj_state_group.nextval INTO :new.id FROM dual; END; / -- bad sequence name and trigger name CREATE SEQUENCE s_ezurlalias_ml_incr; CREATE OR REPLACE TRIGGER ezurlalias_ml_incr_tr BEFORE INSERT ON ezurlalias_ml_incr FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_ezurlalias_ml_incr.nextval INTO :new.id FROM dual; END; /