我的存储过程的参数是这样的:
create or replace procedure cyry_SearchByInfo
(
rfcur out sys_refcursor,
sfzhl varchar2:=20,
xml varchar2:=20,
xbl varchar2:=20,
csrql varchar2:=20,
hjqhl varchar2:=20,
fjl varchar2:=20,
pcsl varchar2:=20,
fwcsl varchar2:=40,
rllybjl varchar2:=10,
dwbh1 varchar2:=20
)
is
我在SQL Developer里执行这样写的:
EXECUTE cyry_SearchByInfo (system.sys_refcursor,'','','','','','','','','','')
报错的,那个输出参数赋值不对,好像不是system.sys_refcursor这个,但是应该怎么写呢?
create or replace procedure cyry_SearchByInfo
(
rfcur out sys_refcursor,
sfzhl varchar2:=20,
xml varchar2:=20,
xbl varchar2:=20,
csrql varchar2:=20,
hjqhl varchar2:=20,
fjl varchar2:=20,
pcsl varchar2:=20,
fwcsl varchar2:=40,
rllybjl varchar2:=10,
dwbh1 varchar2:=20
)
is
我在SQL Developer里执行这样写的:
EXECUTE cyry_SearchByInfo (system.sys_refcursor,'','','','','','','','','','')
报错的,那个输出参数赋值不对,好像不是system.sys_refcursor这个,但是应该怎么写呢?
比如:
DECLARE cur sys_refcursor;
begin
cyry_SearchByInfo (cur,'','','','','','','','','','');
.... --对结果cur的处理
close cur;
end;
CUR SYS_REFCURSOR;
BEGIN
CYRY_SEARCHBYINFO(CUR, '', '', '', '', '', '', '', '', '', '');
。
END;