On Wed, Dec 12, 2001 at 06:26:23PM +0100, Paul Busse wrote:
> Hi,
> 
> 
> Oracle supports queries like
> 
>     SELECT  dname, loc, CURSOR( SELECT * FROM emp WHERE emp.deptno = 
> dept.deptno)
>     FROM dept;
> 
> I would like to use this construct through DBI. However, DBD::Oracle 
> says that he doesn't support
> type 116 (ORA_RSET). This suprised me because returning a cursor through 
> a bound variable in a
> PL/SQL call is supported.
> 
> Will there be any support in the future for nested cursors ?

Probably.

> Is there a reason for not supporting nested cursors ?

Just haven't tried. It's probably a (relatively) simple addition
to the code that's there. Patches welcome.

Tim.

Reply via email to