Skip to main content
Solved

oracle raw data type cannot be translated

  • January 6, 2015
  • 2 replies
  • 28 views
M
Forum|alt.badge.img
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?

Best answer by david_r

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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • January 6, 2015
Hi,

 

Possibly this answer can be of use to you:

 

https://safecommunity.force.com/CommunityAnswers?id=906a0000000clfIAAQ&s=2&
david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • January 6, 2015
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

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.