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