CREATE OR REPLACE procedure LIYANG.xxc_insert_user1(name in varchar2) isbegin declare v_num number:=1; begin loop insert into userid values(v_num,name); exit when v_num=10; v_num:=v_num+1; end loop; end;end;/
少了一个BEGIN。。END