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 -> Function returning an aray and us it in an where clause

Function returning an aray and us it in an where clause

From: Björn Wächter <Bjoern.Waechter_at_p3-solutions.de>
Date: Mon, 27 Jun 2005 09:15:05 +0200
Message-ID: <3i9ncoFjve30U1@news.dfncis.de>


Hi all,

I want to write an stored function
which returns an array of numbers.
Afterwards I want to use this function
in an where clause like:

SELECT *
FROM
VI_USER
WHERE
USER_ID IN GetManagers(2)

Is this possible?

Thanks Björn



Dipl.-Ing. Björn Wächter
P3 Solutions GmbH
Dennewartstr. 25-27
D-52068 Aachen
Germany
http://www.p3-solutions.com

tel +49(0)241/9437-417
fax +49(0)241/9437-431 Received on Mon Jun 27 2005 - 02:15:05 CDT

Original text of this message

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