return cursor from a function and use it in an other statment

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 Received on Fri Jul 07 2000 - 00:00:00 CDT