Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Join sql and pl/sql table-possible?
Well, you can't issue SQL against a PL/SQL table. It's not that kind of table. You could insert the contents to a temporary table and do the join; or you could loop through the PL/SQL table and then match with dbtable. -djc
Marc.Fleischeuers_at_kub.no-spam.nl wrote in article <un2jsr4n4.fsf_at_kub.nl>...
> I want to allow a user to select some (up to 50-ish, max) categories
> in a web page, and display more information using the selected items
> in a subsequent page. The selected items are returned in a pl/sql
> table containing the key values. What I want to do now is a simple
> join:
> procedure generate (my_table in owa_util.num_arr) is
> begin
> select a.id, a.desc from dbtable a, my_table b
> where a.id = b.??
> end;
Received on Wed Oct 29 1997 - 00:00:00 CST