Re: DBD::Oracle: Nested cursors

2001-12-12 Thread Tim Bunce
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 h

DBD::Oracle: Nested cursors

2001-12-12 Thread Paul Busse
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