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