Retreiving index-by table data using JDBC

We have a number of stored procedures which we wish to make more accessible by writing Java Bean wrappers to call
them.

There does not seem to be any problem calling the PL/SQL using JDBC nor passing simple parameters as IN, OUT or
IN/OUT. However, many of the parameters take the form of index-by tables, which can be passed around quite
easily within the PL/SQL environment, but not, it seems, by anything else.

Our usual method to get hold of the data from an index-by table is to write ProC and include a PL/SQL block in which the index-by table is mapped to a host array - datatype conversion being taken care of by the PL/SQL. We could take a similar aproach by writing SQLJ in the Bean and embedding PL/SQL, but that rather defeats the object of making
the Bean capable of running on other platforms.

The succinct question is - Does anyone know a way of passing index-by table values to and from Java by JDBC?

I'd be very pleased to receive any help or pointers.

Ta

Mike Received on Thu Oct 19 2000 - 22:59:58 CEST