Forum Discussion

oktober42's avatar
oktober42
Frequent Visitor
4 years ago
Solved

Oracle database type varray not supported

Hello,   I'm trying to pull data in from an Oracle database and I'm running into errors like "DataSource.Error: Values of column 'COLUMN' have type 'type_number_varray' which is not supported" and ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    You will have to convert (or exclude) these columns as part of your custom SQL query.

lbendlin's avatar
lbendlin
Super User
4 years ago

You will have to convert (or exclude) these columns as part of your custom SQL query.

oktober42's avatar
oktober42
Frequent Visitor
4 years ago

After some fighting and a call for help, we arrived at this query for our source:

= Oracle.Database("our.source/table", [HierarchicalNavigation=true, Query="SELECT ITEM1, ITEM2, JSON_OBJECT(NUM_VALUE) FROM THESOURCE"])

 

Thanks!