FUNCTION getallemp RETURN sys_refcursor
as
type refcursor is ref cursor return emp%rowtype;
emp_refcursor refcursor;
begin
open emp_refcursor for select * from emp;
return emp_refcursor;
end getallemp;该方法返回值是游标,怎么调用该方法并且遍历返回的这个游标呢?求解!!
as
type refcursor is ref cursor return emp%rowtype;
emp_refcursor refcursor;
begin
open emp_refcursor for select * from emp;
return emp_refcursor;
end getallemp;该方法返回值是游标,怎么调用该方法并且遍历返回的这个游标呢?求解!!
仅代表个人观点。