Is something like this possible?
cursor c_pr is
select * from a_table;
fetch c_pr into r_pr;
exit when c_pr%NOTFOUND;
for i in 1..r_pr.number_of_columns
There may be other errors in the code - haven't really checked, but you should get my point. Can I extract column data and number of columns and eventually column names in a way something like above?