Devart Forums

Hi, I'm attempting to port data from Oracle to MySQL using both of the Devart products. I have having difficulty porting Oracle's ADT data type into an appropriate MySQL field. I am using the LoadFromDataset to do the transfer.

Could someone please point me in the right direction for getting the Oracle data into MySQL.

Thanks.

If your TOraQuery component has the ObjectView property set to False, there is one field for each member of OBJECT field.
You can create a MySQL table with such fields, and use the TMyLoader component to load data.

The TOraQuery.ObjectView is set to False however the ADT fields are still only coming in as a single field. I have tried setting this property to True, but still no result.

The ADT fields contain spatial data and I have been able to get the TMyLoader to load the data as blob fields, however, I now don't know how to access the blob data to get my co-ordinates.

What am I doing wrong here?

If you are using SDO_GEOMERTY data type, you can use its methods Get_WKB or Get_WKT to convert a value to BLOB or CLOB (supported starting with Oracle 10). For example:

SELECT t.id, t.geom_field.Get_WKB() FROM geom_table t