When trying to export data from a table, I right click on the table name in Schema Browser. I choose to create files and INSERT statements are created for that table.
But when I try to run the inserts in the Editor, I get:
ERROR at line 42:
ORA-00904: "FIELDLABEL[98]": invalid identifier
This does not happen with all tables.
Sample of incorrect script created: (variables and values list cut off in example)
SET DEFINE OFF;
Insert into ARRAYDATA
(TABLEID, TABLENAME, ARRAYID, SLICEIDX, TABLEDESCRP,
NFIELDS, "FIELDTYPE[0]", "FIELDTYPE[1]", "FIELDTYPE[2]", "FIELDTYPE[3]",
"FIELDTYPE[4]", "FIELDTYPE[5]", "FIELDTYPE[6]", "FIELDTYPE[7]", "FIELDTYPE[8]", .... )
Values
(1, 'a', 's', 2, 'd',
3, 1, 235, 3, 4,
225, 5, 6, 7, 8, .... );
COMMIT;
The insert script being generated for the table is incorrect. This is only an issue for tables with Array data types.
WORKAROUND:
1. Run a query for the data you'd like to export in Toad's data grid (F9).
2. Right click in the results and select " Save As".
3. In the Save As window, choose the format you want to save as, in this case INSERT statements.
4. Make any setting specifcations and note the table and schema.
5. Click OK.
This should generate the correct insert scripts for the table data that handles Array types.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
Sample of correct INSERT query for table with Array type:
Insert into ARRAYDATA
(TABLEID, TABLENAME, ARRAYID, SLICEIDX, TABLEDESCRP, NFIELDS, FIELDTYPE, FIELDLABEL)
Values
(1, 'a', 's', 2, 'd', 3,
"CASEY"."ARRAY_SHORT_99"(1,23,3,4,25,5,6,7,8,9,10,..................,9,1,8,56,5,-76,25,25,95,5,32),
"CASEY"."ARRAY_PHRASE_99"('1','2','2','3','4','56','7','889',...................,'''up','srn6','.p689','srny6',NULL,'r,87','r78,'));
COMMIT;
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center