Oracle has a syntax for nested selects. E.g.
select a, cursor(select b, ....) .....
In each row fetched from such a select, some of the column values are themselves result sets.
DBS::Oracle version 1.16 apparently does not support such select statements. An attempt to prepare such a statement give the reasonable error message
> Field 2 has an Oracle type (116) which is not explicitly supported
Is anyone thinking about the implementation of the fetching of nested result sets? If not, I might look at it myself.
-- Charles Jardine - Computing Service, University of Cambridge [EMAIL PROTECTED] Tel: +44 1223 334506, Fax: +44 1223 334679
