Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: return cursor from a function and use it in an other statment
belspar wrote:
>
> 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
define the cursor as a type in a package - then you can share it amongst several pl/sql routines.
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Fri Jul 07 2000 - 00:00:00 CDT