Is there an easy way to access an Oracle function that returns a TABLE of record TYPEs? (This sort of thing: http://www.oracle.com/technology/sam...es/Readme.html)


The metadata for that parameter seems to come across as:
Code:
DEBUG [org.springframework.jdbc.core.metadata.CallMetaDataProvider] - <Retrieved metadata: null 5 1111 PL/SQL TABLE true>
When the call actually runs we see:
Code:
DEBUG [org.springframework.jdbc.core.simple.SimpleJdbcCall] - <1: return SQL Type 1111 Type Name null org.springframework.jdbc.core.SqlOutParameter>
and then it crashes and burns with:
Code:
Invalid column type; nested exception is java.sql.SQLException: Invalid column type
I've tried .withoutProcedureColumnMetaDataAccess() with similar results.

Any ideas?