oracle - 错误:ORA-06550:第4行，第205列:PLS-00103:在预期以下情况之一时遇到了符号 “end-of-file”:

Question

我正在尝试从 .sql 文件执行匿名阻止。我收到以下错误:

错误:

ORA-06550: line 4, column 205:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

;

匿名块如下:

BEGIN
FOR CUR_VAR IN (select id from opco where countrycode in ('IT','PT','DE','ES','GR','UK', 'IE','NL'))
LOOP
insert into vfservice (id, opco_id, name, service_order, service_template, version, service_key, enabled) values (SEQ_SERVICES_ID.nextval, CUR_VAR.id, 'My Vodafone', 0, 'REMOTE_ANONYMOUS', 0, 'SELFCARE',1);
insert into vfservice (id, opco_id, name, service_order, service_template, version, service_key, enabled) values (SEQ_SERVICES_ID.nextval, CUR_VAR.id, 'Vodafone Cloud', 1, 'REMOTE_AUTHENTICATED', 0, 'CONTENTBACKUP',1);
insert into vfservice (id, opco_id, name, service_order, service_template, version, service_key, enabled) values (SEQ_SERVICES_ID.nextval, CUR_VAR.id, 'Vodafone Contacts', 2, 'REMOTE_AUTHENTICATED', 0, 'CONTACTS',1);
end LOOP ;
END ;

我正在使用grails 3.3.2和数据库迁移工具以及oracle 10g。

Answer 1

只需将/放在文件末尾即可:)

在匿名块中运行过程时，需要使用以下语法:

declare

begin

end;
/