Is is possible to return a set (list) from a function???

From: Hannes Lechner <han_at_sbox.tu-graz.ac.at>
Date: Tue, 15 Sep 1998 16:52:49 +0200
Message-ID: <6tm6v1$t4i@fstgal00.tu-graz.ac.at>

Hi!

i wonder if there's a way to return a list from a PL/SQL function... i'd like to do the following:

SELECT * FROM xyz
WHERE key_id IN mySetReturnFunction(x);

instead of

SELECT * FROM xyz
WHERE key_id IN (SELECT key_id FROM abc WHERE foo > 7)

mySetReturnFunction(x) should return n (n >= 0) rows of xyz.key_id%TYPE

as far as i know this is not possible (at least not in oracle7.3) - but maybe there's another way solve this problem??!

thanks for any help,
Hannes Received on Tue Sep 15 1998 - 09:52:49 CDT