数据库执行脚本报错

数据库执行可重复执行脚本报错

操作背景：向数据库批量打入可重复执行的脚本时报错，拆开单个执行脚本，不报错。
执行的sql语句为：

declare v_rowcount number(5);
begin
  select count(*) into v_rowcount from dual
    where exists (select 1 from 表名1 where 字段名1='' and 字段名2='');
  if v_rowcount = 0 then
    insert into 表名1(字段名1,字段名2,字段名3......) values ('值1','值2','值3'......);
  else
    update 表名1 set 字段名1='值1'字段名2='值2',字段名3='值3' where 字段名1='' and 字段名2='';
  end if;
  commit;
end;

declare v_rowcount number(5);
begin
  select count(*) into v_rowcount from dual
    where exists (select 1 from 表名2 where 字段名1='' and 字段名2='');
  if v_rowcount = 0 then
    insert into 表名2(字段名1,字段名2,字段名3......) values ('值1','值2','值3'......);
  else
    update 表名2 set 字段名1='值1'字段名2='值2',字段名3='值3' where 字段名1='' and 字段名2='';
  end if;
  commit;
end;

报的错误为：`> ORA-06550: line 13, column 1:
PLS-00103: Encountered the symbol “DECLARE”
ORA-06550: line 23, column 4:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<a double-quoted

查资料发现是两个sql语句间缺少了结束分割符，加上结束分割符 / 后，可正常执行批量sql语句。