在使用ref cursor
想问一下,可以使用参数吗?
我试了一下,没试出来,望高人给个答案。以下是我写的测试代码,编译不过
type ref_cursor is ref cursor;
procedure test13(s1 in string,
s2 out number) is
cs(acc varchar2) ref_cursor;
begin
open cs(acc varchar2) for
select count(*) as co
from sip
where (sip.a= acc );
loop
fetch cs(s1).co into s2;
exit when cs%notfound;
end loop
close cs;
end test13;
想问一下,可以使用参数吗?
我试了一下,没试出来,望高人给个答案。以下是我写的测试代码,编译不过
type ref_cursor is ref cursor;
procedure test13(s1 in string,
s2 out number) is
cs(acc varchar2) ref_cursor;
begin
open cs(acc varchar2) for
select count(*) as co
from sip
where (sip.a= acc );
loop
fetch cs(s1).co into s2;
exit when cs%notfound;
end loop
close cs;
end test13;
strSQL varchar2(1000);
strtablename varchar2(1000);
TYPE reference_cur IS REF CURSOR;
db_cur reference_cur;
BEGIN
strSQL :='SELECT * from'|| strtablename ;
OPEN db_cur FOR strSQL;
LOOP
FETCH dblink_cur INTO v_1,v_2,v_3;
EXIT WHEN dblink_cur%NOTFOUND;
-----do something
END LOOP;
END;
随手写的.
有人会说用ref cursor根本没必要再结合参数
是的
我只是想知道有没有这种语法规则