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
; 

是少了分号

posted @ 2017-08-14 09:37  小奋  阅读(10387)  评论(0编辑  收藏  举报