W
wzqin
Unregistered / Unconfirmed
GUEST, unregistred user!
DELPHI调用有返回记录集的存储过程,有一个输入参数,为什么总提示Parameter 'E_ACCOUNTNO' not found?
包:
create or replace package pkg_test
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
过程:
create or replace procedure qry
(
E_ACCOUNTNO in number, --输入参数
p_rc out pkg_test.myrctype
)
as
l_phonenum varchar2(12);
begin
select phonenum into l_phonenum from aa where accountno=e_accountno;
open p_rc for select * from aa where phonenum=l_phonenum;
end;
调用的程序
adostoredproc1.close;
adostoredproc1.Parameters.ParamValues['E_ACCOUNTNO']:=2500278080;
adostoredproc1.Prepared:=true;
adostoredproc1.Open;
包:
create or replace package pkg_test
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
过程:
create or replace procedure qry
(
E_ACCOUNTNO in number, --输入参数
p_rc out pkg_test.myrctype
)
as
l_phonenum varchar2(12);
begin
select phonenum into l_phonenum from aa where accountno=e_accountno;
open p_rc for select * from aa where phonenum=l_phonenum;
end;
调用的程序
adostoredproc1.close;
adostoredproc1.Parameters.ParamValues['E_ACCOUNTNO']:=2500278080;
adostoredproc1.Prepared:=true;
adostoredproc1.Open;