SET serveroutput ON
Declare
  v_prop dept%rowtype;
type lst_column_name
IS
  TABLE OF all_tab_columns.column_name%type INDEX BY binary_integer;
  v_column_name lst_column_name;
BEGIN
  SELECT *
  INTO v_prop
  FROM dept
  WHERE deptno='10';
  dbms_output.put_line('Count='||v_prop.dname);
  SELECT column_name bulk collect
  INTO v_column_name
  From All_Tab_Cols
  WHERE table_name='DEPT'
  AND owner       ='SCOTT';
  FOR i IN 1..v_column_name.count
  Loop
    --insert into excepts select exception_seq.nextval,table_name,v_column_name(i) ,v_prop.v_column_name(i),sysdate from dual;
    dbms_output.put_line(v_prop.v_column_name(i));
  END LOOP;
  COMMIT;
END;
/
    dbms_output.put_line(v_prop.v_column_name(i));
                                *
ERROR at line 21:
ORA-06550: line 21, column 33:
PLS-00302: component 'V_COLUMN_NAME' must be declared
ORA-06550: line 21, column 5:
PL/SQL: Statement ignored