Maybe an example is in order. DBD::Oracle does support inline views, nested queries, and just about any other form of SQL thatyou can pass to it.
My best guess is that you need to use sql_tags ( see the docs ) to explictly state the type of the column generating the error. On Wed, 2005-03-16 at 09:12, Charles Jardine wrote: > 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.
