<b>Inserting data into table with reference to table with nested tables</b>
508959Apr 26 2006 — edited Apr 26 2006Hi !
How can I insert data to table with reference to table with nested tables?
If I use command "select" (sample code below) I've got error: ORA-22979: cannot INSERT object view REF or user-defined REF.
Table MIESZKANIA contain 3 nested tables.
Table LOKATORZY contain 1 nested table.
Sample code:
insert into LOKATORZY values(0001, 'Osuchowski', 'Jan', '60545632',
ZAMIESZKANIA_TYP(ZAMIESZKANIE((select REF(p) from MIESZKANIA p where p.ID_MIESZKANIA=1), to_date('04-12-1990','DD-MM-YYYY'), to_date('04-12-1990','DD-MM-YYYY'))));
Thanks for all helps !