RE:Nested Record [message #157089] |
Tue, 31 January 2006 05:04  |
dhananjay
Messages: 635 Registered: March 2002 Location: Mumbai
|
Senior Member |
|
|
hi,
declare
type emp_1_rec is record(v_name varchar2(30));
type emp_2_rec is record(name emp_1_rec);
name_tab emp_2_rec;
cursor c1 is select ename from test1;
begin
open c1;
loop
fetch c1 into name_tab;
exit when c1%notfound;
dbms_output.put_line(name_tab.name.v_name);
end loop;
end;
error :ORA-06550: line 0, column 0:
PLS-00801: internal error [0]
but if run the following code
SQL> declare
2 type emp_1_rec is record(v_name varchar2(30));
3 type emp_2_rec is record(name emp_1_rec);
4 name_tab emp_2_rec;
5 --cursor c1 is select ename from test1;
6 begin
7 name_tab.name.v_name:='scott' ;
8 dbms_output.put_line(name_tab.name.v_name);
9 end;
10 /
scott
PL/SQL procedure successfully completed.
plz suggest if i m missing out something.
regards,
|
|
|
|
|