Re: oracle multiple cursor sub query in different DBI versions

Thank you for your reply. Indeed I meant any "table", sorry for the
confusion .

I also get the expected results with:

SELECT  (2+3), cursor(select 2+3 from dual), cursor(select 2+3 from
dual) FROM dual where rownum < 10

5 DBI::st=HASH(0x3bf9540) DBI::st=HASH(0x3d9ee70)       5       5

If I do :

select analysis_id from analysis where rownum < 10

I get the expected rows.

select analysis_id, cursor(select 2+3 from dual) from analysis where rownum
< 10

It works fine.

BUT:

select analysis_id, cursor(select 2+3 from dual), cursor(select 2+3 from
dual)  from analysis where rownum < 10

Returns nothing with no errors. There is nothing special about this or any
other table in this database.

Many thanks,
LK








On Thu, Aug 5, 2010 at 4:46 AM, Charles Jardine <[email protected]> wrote:

> On 04/08/10 19:27, LK wrote:
> > In the process of moving from centos 4 to a centos 5 machine one
> > script stopped working. I distilled it down to this problem :
>
> [snip]
>
> > my $q = qq/
> >   SELECT
> >               (2+3),
> >         cursor(select 2+3 from dual),
> >         cursor(select 3+3 from dual)
> >         FROM table where rownum < 10
> > /;
>
> [snip]
>
> I am the author of the code in DBD::Oracle which supports nested cursors.
> I am trying to reproduce your problem.
>
> THE SQL statement quoted above cannot be exactly what you are using,
> because
> 'table' is a reserved word. If I substitute 'dual' for 'table', I get the
> expected results.
>
> Can you let us know whether your problem can be reproduced with 'dual' as
> the
> FROM clause. If not, can you tell us what, if anything, is special about
> the
> actual FROM clause in your test.
>
> --
> Charles Jardine - Computing Service, University of Cambridge
> [email protected]    Tel: +44 1223 334506, Fax: +44 1223 334679
>