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,
View original
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 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.
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.
- 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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.