I'm getting the above error for the following program
Please hint me in this regard.
Code:
SQL> desc dup1
Name Null? Type
----------------------------------------------------------------- -------- ------------------
A NUMBER
SQL> declare
2 type typ_dup1 is table of dup1%rowtype;
3 v_dup1 typ_dup1;
4 begin
5 select * bulk collect into v_dup1 from dup1;
6 dbms_output.put_line(v_dup1.A);
7 end;
8 /
dbms_output.put_line(v_dup1.A);
*
ERROR at line 6:
ORA-06550: line 6, column 29:
PLS-00302: component 'A' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored