Question on varrays with multiple dimensions.

[MarkF]

Hi folks,

I have an example of a multidimensional varray query that my ODAC version doesn't seem to like. Here's the sample code:

Code: Select all

CREATE OR REPLACE TYPE ONE_D AS VARRAY(5) OF INTEGER;
/
CREATE OR REPLACE TYPE TWO_D AS VARRAY(5) OF ONE_D;
/
CREATE TABLE TEST_2D (
  ID     INTEGER PRIMARY KEY,
  DATA   TWO_D NOT NULL
);
INSERT INTO TEST_2D VALUES (1,
     TWO_D(ONE_D(1,1,1,1,1), ONE_D(1,1,1,1,1), ONE_D(1,1,1,1,1),ONE_D(1,1,1,1,1),ONE_D(1,1,1,1,1)));
INSERT INTO TEST_2D VALUES (2,
     TWO_D(ONE_D(2,2,2,2,2), ONE_D(2,2,2,2,2),  ONE_D(2,2,2,2,2),ONE_D(2,2,2,2,2),ONE_D(2,2,2,2,2)));
COMMIT;
SELECT * FROM TEST_2D;

Everything works great until the final selection which gives the error "Field 'DATA[0][0]' not found".

My ODAC version is 7.00.0.3.

Thanks for any help or suggestions.

-Mark

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will notify you as soon as we have any results.