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.
