create or replace procedure proc_provider_register(_table_name PRI_PROVIDER_REGISTER.tablename%type, data_sizes PRI_PROVIDER_REGISTER.sizes%type,batchNumber PRI_PROVIDER_REGISTER.batch1%type)
is
begin
insert into PRI_PROVIDER_REGISTER(sizes,TABLENAME,batch1) values (data_sizes,_table_name,batchNumber);
end;
PROCEDURE SCOTT.PROC_PROVIDER_REGISTER 编译错误
错误:PLS-00103: Encountered the symbol “_” when expecting one of the following:
<an identifier> <a double-quoted delimited-identifier>
current delete exists prior
The symbol "_" was ignored.
行:1
文本:create or replace procedure proc_provider_register(_table_name PRI_PROVIDER_REGISTER.tablename%type, data_sizes PRI_PROVIDER_REGISTER.sizes%type,batchNumber PRI_PROVIDER_REGISTER.batch1%type)
错误:PLS-00103: Encountered the symbol “_” when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
行:4
文本:insert into PRI_PROVIDER_REGISTER(sizes,TABLENAME,batch1) values (data_sizes,_table_name,batchNumber);
异常是参数名以”_”前缀,去掉即可。