I am trying to migrate Oracle dump datas into gdb. The reader reads every column except raw format type and giving a warning "skipping column". Has anybody have any idea?
Solved
FME ORACLE REader cant see the "raw" format columns
Hi there,
Best answer by david_r
Hi,
that is because a Raw column can contain just about anything. You need to specify the contents in some way, e.g. if it contains a UUID you can convert it to a string containing a hexadecimal representation of the contents using the Oracle function RawToHex().
One way to read such an Oracle table would be by using a SQLCreator rather than the regular Oracle reader, using a query such as:
select
OBJECTID,
rawtohex(MY_UUID) as MY_UUID,
NAME
from
MYTABLE
For the above example, you would expose the attributes OBJECTID, MY_UUD and NAME in the SQLCreator.
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.
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.
- Best Answer
Hi,
that is because a Raw column can contain just about anything. You need to specify the contents in some way, e.g. if it contains a UUID you can convert it to a string containing a hexadecimal representation of the contents using the Oracle function RawToHex().
One way to read such an Oracle table would be by using a SQLCreator rather than the regular Oracle reader, using a query such as:
select
OBJECTID,
rawtohex(MY_UUID) as MY_UUID,
NAME
from
MYTABLE
For the above example, you would expose the attributes OBJECTID, MY_UUD and NAME in the SQLCreator.
David