CURSOR

Question

Hi,

  I have cursor in oracle. I want to call it from c# program.
DECLARE

  CURSOR c_table IS

    SELECT table_name FROM user_tables WHERE table_name LIKE 'PDTABLE_12_%';

  sys_no  VARCHAR2(64);

  line_no VARCHAR2(64);

  line_id VARCHAR2(64);

  par_no  VARCHAR2(64);

  c SYS_REFCURSOR;

BEGIN

  FOR t IN c_table LOOP

    OPEN c FOR 'select LINE_NUMBER_LABEL,LINE_ID,PARTITION_NO  from ' || t.table_name;

    FETCH c INTO sys_no,line_no , line_id , par_no 
    WHILE c%FOUND LOOP

      dbms_output.put_line('System_unique_number :' || t.table_name||line_no||line_id||parnp);

      FETCH c INTO sys_no,line_no , line_id , par_no  ;

    END LOOP;

  END LOOP;

END;

 

I want to get result in data set

 

Please help to solve the task