Skip to main content
  • EN
Hi Everyone, 

 

 

I'm trying to translate an table in one Oracle database to another Oracle database. From production to development for this case. The problem is that FME will not write a RAW Oracle datatype. 

 

 

This appears to be intended functionality since the message I get from the FME log is "Oracle Reader: Skipping column '<column_name>' of Oracle Spatial layer '<schema.table>', which is reporting a data type of 'RAW' "

 

 

Can anyone give me some insight into wether this is intended functionality or if it is buggy?
Hi,

 

Possibly this answer can be of use to you:

 

https://safecommunity.force.com/CommunityAnswers?id=906a0000000clfIAAQ&s=2&
Hi,

 

 

FME doesn't support Oracle RAW datatypes, at least up to and including FME 2014 SP5. You will therefore have to manually cast these datatypes to e.g. VARCHAR2, as described in the answer that Itay linked to.

 

 

It seems that RAW support has been added in FME 2015, but I haven't tested it yet.

 

 

David

Reply


Community Stats

30,351
Posts
115,342
Replies
38,082
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.