存储过程执行时的错误,y?

simonpan

create or replace procedure test1(par1 in out varchar2,par2 in out varchar2,par3 in out varchar2,par4 in out varchar2,par5 in out varchar2)
is
begin
  insert into dlgh (dlgh_gh,dlgh_mm,dlgh_bm,dlgh_mc,dlgh_qx)values(par1,par2,par3,par4,par5);
end test1;

execute test1('1','1','1','1','1');
错误如下：

///////////////////////////////////////////////////

begin test1('1','1','1','1','1'); end;

ORA-06550: line 1, column 13:
PLS-00363: expression '1' cannot be used as an assignment target
ORA-06550: line 1, column 17:
PLS-00363: expression '1' cannot be used as an assignment target
ORA-06550: line 1, column 21:
PLS-00363: expression '1' cannot be used as an assignment target
ORA-06550: line 1, column 25:
PLS-00363: expression '1' cannot be used as an assignment target
ORA-06550: line 1, column 29:
PLS-00363: expression '1' cannot be used as an assignment target
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

rollingpig

呵呵,这里涉及一个很基础的编程问题

左手,右手
比如
a=b
中
a就是左手
b就是右手

变量可以充当左手或右手
而常量只能充当右手

对于
par1 in out varchar2
par1是一个out parameter,必须具有左手属性
而'1'显然不能

所以,你的
par1 in out varchar2

应该改成
par1 in  varchar2

simonpan

哦~~~~~知道了，多谢多谢！