Hi all,
I wondered whether anyone had come across any issues reading in data from an Oracle DB with type LONG RAW. It seems FME cannot read in data of this type and 'skips' that column when reading in an Oracle DB table.
Does anyone have any pearls of wisdom on how I could load this data in to my FME workflow?
Thanks all,
Amber
Which version of FME is this?
Are you using the Oracle non-spatial reader, or are you going through some middleware like ArcSDE?
One thing to test is to use the SQLExecutor and the TO_LOB() function to cast the LONG RAW to LOB, for example:
SELECT TO_LOB(MY_LONG_RAW_COLUMN) AS MY_LOB FROM MY_TABLE
See:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions185.htm