fetch recordset

 Ok, my previous post ref cursor in oracle is too long for me to read, so I am starting a new thread.

I created the procedure with cursors successfully. Now, I am in the process of trying to fetch the recordset. I try the fetch all the data from different tables in one go. However, I am not be successful. I am turning this to gurus to see if I can get any help.

set serveroutput on
DECLARE
  TYPE T_CUR1 IS REF CURSOR;
  C_CUR1 T_CUR1;
  TYPE T_CUR2 IS REF CURSOR;
  C_CUR2 T_CUR2;
  TYPE T_CUR3 IS REF CURSOR;