Question

PLSQL执行存储过程提示ORA-01008

create or replace procedure PUBSP_AddHSDW(
Akjnd char,

Agsdm_sys char,

Azth_sys char,

Agsdm char,

Agsmc varchar,

Aczyid integer,

Ayzsj varchar,

yzModule int,

AResCur in out pkg_anyir9.anyiresultset
)

AS

iCount integer;

v_Error VARCHAR2(500); -- 错误信息

begin

open AResCur for select '0' from dual;

if yzModule=0 then

........

end;
求指导一下菜鸟 PLSQL窗口执行
================================================================================
PUBSP_AddHSDW('2014','99999999999999999999','99999999999999999999','12345','xxx',1,'00',0, :pRecCur);
执行出错
ORA-01008:并非所有变量都已绑定

Answer 1

下面是我自己的测试：
SQL> exec rhys1(:a);
begin rhys1(:a); end;
ORA-01008: not all variables bound

SQL> variable a number;
SQL> exec :a :=1;
PL/SQL procedure successfully completed
a
---------
1
SQL> exec rhys1(:a);
PL/SQL procedure successfully completed
a
---------
1

你需要做的是：
1、SQL> variable pRecCur number;
2、SQL>exec :pRecCur :=输入你的值;
3、SQL>exec PUBSP_AddHSDW('2014','99999999999999999999','99999999999999999999','12345','xxx',1,'00',0, :pRecCur);