From: belspar <belspar@voila.fr>
Subject: return cursor from a function and use it in an other statment
Date: 2000/07/07
Message-ID: <3k8bmskl50p7v5vdri6s30q30105rssn24@4ax.com>#1/1
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@oleane.net
X-Trace: s2.feed.news.oleane.net 962962460 70422 195.25.229.219 (7 Jul 2000 09:34:20 GMT)
Organization: a
Mime-Version: 1.0
Reply-To: belspar@voila.fr
NNTP-Posting-Date: 7 Jul 2000 09:34:20 GMT
Newsgroups: comp.databases.oracle.misc


hi all 

my problem is that i have a function which retrieve me lot of data in
a cursor :

myfunction(Aparam in integer) return refcursortype ;

and I want to use it in a select statment like :

select  some,data,a,b 
From table
where  some = 1 And  data in (myfunction(1)) ;

today i must use this statment :

select  some,data,a,b 
From table
where  some = 1 And  data in (select ... from othertable where
otherdata in selec( ...)) ;

and i use it lot of time with different parameters , so  I want to
create a function.
I think the "select"  in the "where"  has the same type as the cursor
returned by my function no ??
 i use oracle 8i enterprise

thanks a lot for help

NB: sorry for my poor english , I'm french