PLS-00103: 出现符号 "end-of-file"-一个存储过程问题
点击右边红色标题查看本文完整版：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)
;
是少了分号吧
