How to loop through columns in an oracle pl/sql cursor.
- by Lloyd
I am creating a dynamic cursor and I would like to loop over the columns that exist in the cursor. How would I do that?
For example:
create or replace procedure dynamic_cursor(empid in varchar2, RC IN OUT sys_refcursor) as
stmt varchar2(100);
begin
stmt := 'select * from employees where id = ' || empid;
open crs for stmt using val;
for each {{COLUMN OR SOMETHING}}
--TODO: Get this to work
loop;
end;
