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?

score 6 · Accepted Answer · edited Jul 09 '12 at 16:21

6

edited Jul 09 '12 at 16:21

Xavi López

answered Jan 19 '09 at 15:59

tuinstoel

1

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... – Andy Jan 20 '09 at 11:00
@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. – Xavi López Jul 09 '12 at 15:21

score 1 · Answer 2 · answered Aug 24 '17 at 18:43

1

Note that arrayTypeName should be the table of type.

answered Aug 24 '17 at 18:43

Arlo

2 Answers2