存储过程参数不能带“_”前缀

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);

异常是参数名以”_”前缀,去掉即可。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值