unable to refer the record type using table type
hi,
i am getting some error when i am referring a table type which is define don record type
declare
type t_rec is record (v_emp emp%rowtype);
type t_tab is table of t_rec;
l_tab t_tab;
begin
select * bulk collect into l_tab from emp where empno=7788;
dbms_output.put_line(l_tab)
end;
please give some explanation on this.
Thanks in Advance
0