Creating package-level associative array in java

Question

Is it possible to create a java representation of a package-level oracle associative array. For example, given the following:

CREATE OR REPLACE PACKAGE MyPackage AS
    TYPE t_numbers IS TABLE OF NUMBER INDEX BY PLS_INTEGER;

I find I cannot write the following java:

ArrayDescriptor descriptor =
    ArrayDescriptor.createDescriptor("MyPackage.t_numbers", connection);

(throws a SQLException "Invalid name pattern").

What is the correct syntax for an ArrayDescriptor referencing a package-level associative array? Does such a thing even exist?

Xavi López · Accepted Answer · 2012-07-09 16:21:28Z

6

See http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3696816290928 and especially http://download.oracle.com/docs/cd/B10501_01/java.920/a96654/oci_func.htm#1017512 .

edited Jul 9, 2012 at 16:21

Xavi López

27.9k11 gold badges100 silver badges167 bronze badges

answered Jan 19, 2009 at 15:59

tuinstoel

7,30629 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andy Over a year ago

Second link was spot on, thanks. To summarize - don't use ArrayDescriptor when referencing package-level associative arrays. Cast the callable statement to an OracleCallableStatement and use setPlsqlIndexTable. Doesn't support records, though...

Xavi López Over a year ago

@Andy many thanks for your comment. It helped me solve the same issue you had, even with link rot affecting the answer's second link.

Arlo · Accepted Answer · 2017-08-24 18:43:10Z

1

You can also use OracleConnection.createOracleArray()

Note that arrayTypeName should be the table of type.

Also, you may find my my answer on getArray() and writeArray() useful.

answered Aug 24, 2017 at 18:43

Arlo

1,3512 gold badges17 silver badges26 bronze badges

Collectives™ on Stack Overflow

Creating package-level associative array in java

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related