Toad World® Forums

I can't retrieve the 2D varray columns from table.

I created two varrays and table that uses the second 2D varray type as one of the fields like these.

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
);
/
After creating the table containing the 2 dimentional user-defined type as a column, inserted two records without any problems.

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;
Now everything was prepared.
If you run the following query in SQL*Plus or Oracle SQL Developer, there is no problems with retrieving the data store that table.

        SELECT * FROM Test_2D;

But when I tried the query in my Toad(v10.6), it complained like this, and did retrieve any records from the table.
"Qry: Field 'DATA[0][0]' not found"
This complaint appears at not only the 'Editor' but 'Schema Browser' when you choose the data tap on RHS.

Help me to solve this problem, please.