While looping through a cursor I need to loop through each column without knowing the column name. For instance
This works:
LOOP
FETCH MVAR_cursor into MVAR_record;
EXIT WHEN MVAR_cursor%NOTFOUND;
MVAR_record.COLUMNNAME1;
MVAR_record.COLUMNNAME2;
END LOOP;
CLOSE MVAR_cursor;
Since I won't know the column name, I need something like this:
LOOP
FETCH MVAR_cursor into MVAR_record;
EXIT WHEN MVAR_cursor%NOTFOUND;
i := i+1;
MVAR_record.column(i);
END LOOP;
CLOSE MVAR_cursor;
thx
Start Free Trial
