PLS-00103: 出现符号 "end-of-file"-一个存储过程问题

PLS-00103: 出现符号 "end-of-file"-一个存储过程问题

create or replace procedure daoru
as
begin
insert into bstc.aaa
select hs_modified_time||'2',f_name,hs_sid,hs_uuid,hs_state,hs_is_deleted from T_USR_XMSX@to_olddb
end;

报错： 
行号= 6错误文本= PLS-00103: 出现符号 "end-of-file"在需要下列之一时：  begin case declare  end exception exit for goto if loop mod null pragma raise  return select update while with <an identifier>  <a double-quoted delimited-identifier> <a bind variable> < <  close current delete fetch lock insert open rollback  savepoint set sql execute commit forall merge pipe 



------解决方法--------------------------------------------------------
insert into bstc.aaa
select hs_modified_time||'2',f_name,hs_sid,hs_uuid,hs_state,hs_is_deleted from T_USR_XMSX@to_olddb
; 

是少了分号

转载于:https://www.cnblogs.com/good-tomorrow/p/7356119.html