Oracle租户在odc批量执行sql脚本时识别Delimiter有问题

建议与反馈 产品缺陷反馈
, ,
#1

使用OB的oracle4.2，在odc4.3.3执行一些复杂的ddl脚本 如触发器脚本时，无法识别设置中的Delimiter

设置Delimiter为/字符时会报错

ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘/’ at line 16

样例sql


CREATE SEQUENCE S_TCOMPANY_INDUSTRY INCREMENT BY 1 MINVALUE 1 MAXVALUE 999999999999999999999999999 NOCYCLE CACHE 20 NOORDER;
/
CREATE OR REPLACE TRIGGER "INSERT_TCOMPANY" 
  BEFORE INSERT ON TCOMPANY
  FOR EACH ROW
BEGIN
  IF :NEW.COMP_ID IS NULL THEN
    SELECT S_AOTOINC_DEFAULT.NEXTVAL
    INTO   :NEW.COMP_ID
    FROM   DUAL;
  END IF;

  IF :NEW.COMP_CODE IS NULL THEN
    :NEW.COMP_CODE := :NEW.COMP_ID;
  END IF;
END;

/

CREATE SEQUENCE S_AOTOINC_DEFAULT INCREMENT BY 1 MINVALUE 1 MAXVALUE 999999999999999999999999999 NOCYCLE CACHE 20 NOORDER;

而且在使用数据导入时也会错误的识别，且无法设置Delimiter