Skip to main content
Solved

oracle raw data type cannot be translated


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
  • 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
  • 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

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