Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> problem with nested tables
When I execute the following from the command line, it works great,
adding the item to the list nested table inside the table hierarchy.
insert into the (select list from hierarchy where id = 0) values( h_item(1, 'bob',0));
But when I do the exact same thing inside a function, I get
PLS-00382: expression is of wrong type
Please help! Received on Thu Jun 24 1999 - 02:46:17 CDT
![]() |
![]() |