Hi all,
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.
The following link will show you the results from both the SQL*Plus and
Toad(Schema Browser)
Error_Image