PLSQL Table Index by VARCHAR2
Is it possible to pass a PLSQL Table which is indexed by VARCHAR2 from a Stored Procedure using JDBC and read it in Java. From the JDBC Developer Guide I couldnt get much information. Nor anything is mentioned that only
PLSQL Table which is indexed by BINARY_INTEGER should be used.
Example:
I have five cities and its population.
There is a PLSQL Table which is indexed by the city name (VARCHAR). Corresponding to the cityname the population is filled.
I want to retrieve this PLSQL table in Java. If its possible, then how am I supposed to get the (key,value) pair.