On 05/08/10 13:41, lokasu lokasu wrote: > 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
Thank you for all the above. I have now managed to reproduce the problem. The outer table needs to have at least two rows. The significant difference seems to be the version of the Oracle client. On my platform, everything works if I use the Oracle 10 full client. I see your problem if I use the Oracle 11.2 instant client. The versions of everything else are the same. I am afraid that I have very little time to work on this, so a solution may not come quickly. -- Charles Jardine - Computing Service, University of Cambridge c...@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
