Re: Array from PLSQL to Java via JDBC sqlType=2003

In article <1015921117.322048_at_makrell.interpost.no>, "Frank" says...
>
>Hi!
>Oracle v9.0.1.0.1/JDK1.3.1_02.
>
>I've made a PLSQL package that return some arrays. I wanted to retrieve this
>arrays in Java via JDBC using

well, technically, plsql doesn't have arrays -- plsql can use:

o index by tables
o nested table collections
o varray collections

how to bind to index by tables differs from the collection types. It can only be done with the THICK OCI driver (index by tables). The collection types can bound to by thick or thin.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:668883049892

for examples of all of the above (index by tables, passing a collection to plsql from java, returning a collection to java from plsql)

>"cstmt.registerOutParameter(1, java.sql.Types.ARRAY)", but run into a
>"Parameter Type Conflict: sqlType=2003" so far.
>I get the impression from some metalinks that others have had the same
>problem.
>(http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
>base_id=FOR&p_id=149014.999)
>But I wanted to check; have anyone made it work in Oracle 9.0.1.0.1 or
>earlier versions?
>
>Frank
>
>Postings are my personal opinions/views.
>I'm not speaking on behalf of any company/organization/institution.
>If the posting is mission version numbers; assume:
>Oracle v9.0.1.0.1/JDK1.3.1_02
>
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp