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

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

CREATE OR REPLACE  PROCEDURE "MES"."SP_SYS_OBJECTITEM" (
  v_tableName in varchar2
)
as
begin
insert into TableName(table_name, column_name, column_type, column_length)
select table_name, column_name, data_type, data_length from user_tab_columns
  where table_name=UPPER(v_tableName)
end;


报错：
行号= 6 列号= 2 错误文本= PL/SQL: SQL Statement ignored
行号= 8 列号= 40 错误文本= PL/SQL: ORA-00933: SQL 命令未正确结束
行号= 9 列号= 4 错误文本= 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 TableName(table_name, column_name, column_type, column_length)
select table_name, column_name, data_type, data_length from user_tab_columns
  where table_name=UPPER(v_tableName)
;

是少了分号吧