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
;
是少了分号