Ora7.3, JDBC and PL/SQL-Tables?

Is there a way to retrieve PL/SQL-tables as Java-Arrays from stored procedures with Oracle 7.3 ?

If so, what SQL-typemapping has to be used in registerOutParameter? Do I have to provide user-defined typemapping?

So far, I tried the following (to no avail):

(1)

registerOutParameter with Types.ARRAY or Types.OTHER throws 'internal type unknown'

(2)

extending the connection's typemap with an own SqlData-Interface and calling registerOutParameter accordingly throws 'PLS-00201: Identifier 'DBMS_PICKLER.GET_FORMAT' must be declared'

Any hints would be appreciated

Werner Ebert Received on Wed Feb 02 2000 - 02:08:52 CST