Skip to main content
Solved

oracle raw data type cannot be translated

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
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • January 6, 2015
Hi,

 

Possibly this answer can be of use to you:

 

https://safecommunity.force.com/CommunityAnswers?id=906a0000000clfIAAQ&s=2&
david_r
Evangelist
  • david_rEvangelist
  • 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

Most helpful members this week

Community Stats

30,847
Posts
116,944
Replies
38,670
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.