17,377
社区成员
发帖
与我相关
我的任务
分享
select userid,username from usertbl where place = in_place; //in_place为传过来的参数
create or replace procedure GetUser (result1 out sys_refcursor)
as
begin
open result1 for select userid,username from usertbl;
end;
CREATE OR REPLACE PROCEDURE Proc_Test(Vx out REF CURSOR)
is
cursor mycursor is select userid,username from usertbl;
begin
open mycursor ;
while mycursor %found loop
fetch mycursor into Vx;
end loop;
close mycursor;
end;