2 Replies Latest reply: Jun 9, 2009 8:23 PM by user10133982 RSS

    How to read the associated multi-table result set cursor

    user10133982
      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;