Re: Oracle adapter – getting multiple results (rowset)

The adapter doesn't support UDT's. You might want to consider using a view.

Alternatively, you could use return a Ref Cursor using NativeSQL. You can find more info and samples in the Documentation.