How to call Oracle function returning Table of record

Question

I have to get data from a function which returns a table of record. For example

Package is pkg1

Record defined inside package is:

type rec is record(id number,name varchar2(40));

Table of Record defined inside package is:

type rec_tbl is table of rec;

Function defined inside package is :

FUNCTION get_rec_tbl() RETURN rec_tbl;

Now What I need to do is: Using spring jdbc or spring jdbctemplate get values from function and process it. I am not sure how to do this.

Can some one help?

Answer 1

RECORD type is not directly supported by Oracle JDBC drivers.

There is an ugly workaround, as an official JDBC reference states. Never used it myselft, thought.