Currently I have a proc:
CREATE OR REPLACE PROCEDURE CDR.Test(C_CUR IN SYS_REFCURSOR) IS
v_rowid test.text%TYPE;
v_test test.text%TYPE;
v_test2 test.text2%TYPE;
v_test3 test.num%TYPE;
BEGIN
-- LOOP
-- FETCH C_cur INTO v_rowid, v_test, v_test2, v_test3;
-- EXIT WHEN...