hi can you help me with this:
I have two object types tt and under_tt, under_tt was created under tt, both having corresponding object tables tt_tab and uner_tt_tab.
i already hav some objects in under_tt_tab, i want to these object into tt_tab.
this is what i tried with oracle 10g, but doesnt work:
Create or replace procedure test as
Cursor cur_sample is
Select * from under_tt_tab ;
fetch cur_sample into v;
exit when cur_sample%notfound;
insert into tt_tab values(under_tt(v.bno, v.bname, v.mi, v.blo));
description of tables:
tt= bno, bname
under_tt = bno,bname,mi,blo
please show me how to insert into tt using substitutable feature of oracle 10g