DevOps, CI/CD and Automation

How to read the associated multi-table result set cursor

create or replace package Testcursor is

procedure test( io_cursor OUT sys_refcursor);

end Testcursor;


create or replace package body Testcursor is

procedure test(io_cursor OUT sys_refcursor) is
v_cursor sys_refcursor;

begin
if length(trim(i_containerbarcode)) IS NULL
then
OPEN v_cursor FOR Select a.ID,a.Name,b.Code From a,b where a.ID=b.ID and rownum<2;
end if;
/*****************************************
How to read the associated multi-table result set cursor,For example,Read a.id value

*****************************************/
io_cursor:=v_cursor;
end;


end Testcursor;