Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> problem with nested tables

problem with nested tables

From: Dan <dan_at_onshare.com>
Date: Thu, 24 Jun 1999 03:46:17 -0400
Message-ID: <3771E249.D6728D64@onshare.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US