> 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.
That could be quite neat; presumably the code that supports returning REF CURSORs from PL/SQL as statement handles can be re-used here when fetching them from a result set? -- Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
