2 Replies Latest reply: May 14, 2014 8:16 AM by Jeff Smith Sqldev Pm-Oracle RSS

    sql terminator error at sql developer tool v.4.0.1.14

    kargenc

      CREATE OR REPLACE TRIGGER LMSTARIFF_M_EO BEFORE INSERT ON A.LMST_TARIFF_M

      FOR EACH ROW BEGIN SELECT A.TARIFF_ID_LMST_TARIFF_M.NEXTVAL INTO :NEW.TARIFF_ID FROM DUAL; END;

      /

       

      when i execute this script at oracle sql developer tool v.4.0.1.14 its run first  this  (F5 run script)

      CREATE OR REPLACE TRIGGER LMSTARIFF_M_EO BEFORE INSERT ON A.LMST_TARIFF_M

      FOR EACH ROW BEGIN SELECT A.TARIFF_ID_LMST_TARIFF_M.NEXTVAL INTO :NEW.TARIFF_ID FROM DUAL

      and after this

      END

       

      i try to set sqlterminator '/'

       

      but no way, anyone has a advice for it,

      i must run this script like that with '/' sqlterminator char.