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

I tried to do this and gave up after some toothgrinding, and finding that some (roguewave?) drivers will not let you do it. Will follow your thread.

Werner Ebert wrote:

> 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 Mon Feb 07 2000 - 18:08:59 CST