Trying to convert the data from Access DB to Oracle non spatial tables. Column is number at writer but the values shows as double with precision values so data format voilation after conversion, Am i mssing any configurations? shows problem in detail.
Question
Conversion of data from Access DB to Oracle non spatial, data format voilation
+3This 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.
I couldn't reproduce your conversion issue. NUMBER is a floating point value in Oracle so if FME thinks you have a floating point value it will use a floating point value. Make sure that the FME Oracle Writer Feature Type has the correct data type set. The issue might arise in Access, so if you want to attach a small sample Access database that illustrates the problem that might help us isolate the problem.
+3I couldn't reproduce your conversion issue. NUMBER is a floating point value in Oracle so if FME thinks you have a floating point value it will use a floating point value. Make sure that the FME Oracle Writer Feature Type has the correct data type set. The issue might arise in Access, so if you want to attach a small sample Access database that illustrates the problem that might help us isolate the problem.